9.149 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 Database 23ai.