V$PX_PROCESS_DETAIL

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

Column Datatype Description
SPID VARCHAR2(24) Operating system process ID
SERVER_NAME VARCHAR2(7) Name of the PX server (P000, P001, and so on)
STATISTIC VARCHAR2(30)

Name of the statistic:

  • Start Time

  • Cleanup Start Time

  • Cleanup End Time
VALUE VARCHAR2(64)

String representation of the value the statistic

For example, if the value of the statistic is a timestamp, this column displays a string containing the timestamp information.
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.