Dynamic Performance (V$) Views, 134 of 238

V$PQ_SESSTAT

This view 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 slave processes used, and other information for the session and system.

Column Datatype Description

Column	Datatype	Description
`STATISTIC`	`VARCHAR2(30)`	Name of the statistic: `Queries Parallelized` - Number of queries run in parallel `DDL Parallelized` - Number of DDL operations run in parallel `DML Parallelized` - Number of DML operations run in parallel `DFO Trees` - Number of executed DFO trees `Server Threads` - Total number of cluster databases used `Allocation Height` - Requested number of servers per instance `Allocation Width` - Requested number of instances `Local Msgs Sent` - Number of local (intra-instance) messages sent `Distr Msgs Sent` - Number of remote (inter-instance) messages sent `Local Msgs Recv'd` - Number of local (intra-instance) messages received `Distr Msgs Recv'd` - Number of remote (inter-instance) messages received
`LAST_QUERY`	`NUMBER`	Value of the statistic for the last operation
`SESSION_TOTAL`	`NUMBER`	Value of the statistic for the entire session to this point in time

STATISTIC

VARCHAR2(30)

Name of the statistic:

Queries Parallelized - Number of queries run in parallel
DDL Parallelized - Number of DDL operations run in parallel
DML Parallelized - Number of DML operations run in parallel
DFO Trees - Number of executed DFO trees
Server Threads - Total number of cluster databases used
Allocation Height - Requested number of servers per instance
Allocation Width - Requested number of instances
Local Msgs Sent - Number of local (intra-instance) messages sent
Distr Msgs Sent - Number of remote (inter-instance) messages sent
Local Msgs Recv'd - Number of local (intra-instance) messages received
Distr Msgs Recv'd - Number of remote (inter-instance) messages received

LAST_QUERY

NUMBER

Value of the statistic for the last operation

SESSION_TOTAL

NUMBER

Value of the statistic for the entire session to this point in time