|
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 |
