Name
V$SHARED_SERVER
Synopsis
The V$SHARED_SERVER view returns one row for each shared server process. Table 7.6 describes the columns in this view.
Table G-6. V$SHARED_SERVER Column Descriptions
|
Column Name |
Description |
|---|---|
|
NAME |
The name of the shared server, which is S000, S001, S002, and so forth. This name forms part of the operating system’s name for the shared server process. |
|
PADDR |
The shared server’s process address. |
|
MESSAGES |
The total number of messages handled by the shared server process. |
|
BYTES |
The total number of bytes in all the messages handled by the shared server process. |
|
CIRCUIT |
The address of the circuit currently being serviced. This matches a value in the CIRCUIT column of the V$CIRCUIT view. |
|
IDLE |
The cumulative amount of time that the shared server has been idle. This is in hundredths of a second. |
|
BUSY |
The cumulative amount of time that the shared server process has been busy. This is in hundredths of a second. |
|
REQUESTS |
The cumulative number of requests that this shared server process has taken from the common request queue and executed. |
|
STATUS |
The current status of the shared server process. This is one of the following values:
|