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:
|
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access