9.41 V$SHARED_SERVER

V$SHARED_SERVER displays 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 (RECEIVE) - Waiting for records to be shown in the client application

  • 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 the circuit currently being serviced

IDLE

NUMBER

Total idle time (in hundredths of a second)

BUSY

NUMBER

Total busy time (in hundredths of a second)

IN_NET

NUMBER

Total incoming network wait time (in hundredths of a second)

OUT_NET

NUMBER

Total outgoing network wait time (in hundredths of a second)

REQUESTS

NUMBER

Total number of requests taken from the common queue in this server's lifetime

BOUND_TIMEFoot 1

NUMBER

Time that a circuit and shared server have been bound (in centiseconds)

BOUND_REASONFootref 1

VARCHAR2(32)

Provides a reason (a short explanation) for why a shared server and circuit could not be unbound.

This column is empty when a circuit is not bound to a server.

When the server starts serving a circuit, BOUND_REASON is empty and remains empty unless the server tries unsuccessfully to unbind the circuit (after it finishes serving the current request).

When this column is not empty, it will be cleared once the server and circuit are unbound (that is, once the resources preventing the session migration to another shared server are released).

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1.