V$PQ_SESSTAT

This view lists session statistics for parallel queries.

Column

Datatype

Description

STATISTIC

VARCHAR2(30)

The following statistics (fixed rows) have been defined for this view. 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.

Name of the statistic:

Queries Parallelized - number of queries 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

The value of the statistic for the last operation

SESSION_TOTAL

NUMBER

The value of the statistic for the entire session to this point in time