1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$IM_COLUMN_LEVEL to V$RULE_SET_AGGREGATE_STATS
  4. V$PX_PROCESS_DETAIL

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