V$SHARED_SERVER

This view contains information on the shared server processes.

Column	Datatype	Description
`NAME`	`VARCHAR2(4)`	Name of the server
`PADDR`	`RAW(4 \| 8)`	Server's process address
`STATUS`	`VARCHAR2(16)`	Server status: `EXEC` - Executing SQL `WAIT` (ENQ) - Waiting for a lock `WAIT` (SEND) - Waiting to send data to user `WAIT` (COMMON) - Idle; waiting for a user request `WAIT` (RESET) - Waiting for a circuit to reset after a break `QUIT` - Terminating
`MESSAGES`	`NUMBER`	Number of messages processed
`BYTES`	`NUMBER`	Total number of bytes in all messages
`BREAKS`	`NUMBER`	Number of breaks
`CIRCUIT`	`RAW(4 \| 8)`	Address of circuit currently being serviced
`IDLE`	`NUMBER`	Total idle time (in hundredths of a second)
`BUSY`	`NUMBER`	Total busy time (in hundredths of a second)
`REQUESTS`	`NUMBER`	Total number of requests taken from the common queue in this server's lifetime