9.127 V$PQ_SESSTAT
V$PQ_SESSTAT
lists session statistics for parallel queries.
After you have run a query or DML operation, you can use the information derived from V$PQ_SESSTAT
to view the number of PX (Parallel Execution) servers used, and other information for the session and system.
Column | Datatype | Description |
---|---|---|
|
|
Name of the statistic:
|
|
|
Value of the statistic for the last operation |
|
|
Value of the statistic for the entire session to this point in time The value of the statistic for the entire session to this point in time is not maintained for the |
|
|
The ID of the container to which the data pertains. Possible values include:
|