V$PX_SERVER

V$PX_SERVER lists statistics for each of the active PX (Parallel Execution) servers on an instance.

Column Datatype Description
SERVER_NAME VARCHAR2(4) Name of the PX server
STATUS VARCHAR2(4)

Current status of the PX server:

  • BUSY

  • IDLE
SESSIONS NUMBER Number of sessions that have used this PX server
IDLE_TIME_CUR NUMBER Amount of time spent idle while processing statements in the current session
BUSY_TIME_CUR NUMBER Amount of time spent busy while processing statements in the current session
CPU_SECS_CUR NUMBER Amount of CPU time (in seconds) spent on the current session
MSGS_SENT_CUR NUMBER Number of messages sent while processing statements for the current session
MSGS_RCVD_CUR NUMBER Number of messages received while processing statements for the current session
IDLE_TIME_TOTAL NUMBER Total amount of time (in minutes) this PX server has been idle
BUSY_TIME_TOTAL NUMBER Total amount of time (in minutes) this PX server has been active
CPU_SECS_TOTAL NUMBER Total amount of CPU time (in seconds) this PX server has used to process statements
MSGS_SENT_TOTAL NUMBER Total number of messages this PX server has sent
MSGS_RCVD_TOTAL NUMBER Total number of messages this PX server has received
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

Note: This view is available starting with Oracle AI Database 26ai.