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_SYSSTAT to view the number of slave processes used, and other information for the system.
|
|
|
Name of the statistic:
- Servers Busy - number of currently busy servers on this instance
- Servers Idle - number of currently idle servers on this instance
- Servers Highwater - number of active servers on this instance that have partaken in >= 1 operation so far
- Server Sessions - total number of operations executed in all servers on this instance
- Servers Started - total number of servers started on this instance
- Servers Shutdown - total number of servers shutdown on this instance
- Servers Cleaned Up - total number of servers on this instance cleaned up due to process death
|
|
|
- Queries Initiated - total number of parallel queries initiated on this instance
- DML Initiated - total number of parallel DML operations that were initiated
- DFO Trees - total number of DFO trees executed on this instance
- Local Msgs Sent - total number of local (intra-instance) messages sent on this instance
- Distr Msgs Sent - total number of remote (inter-instance) messages sent on this instance
- Local Msgs Recv'd - total number of remote (inter-instance) messages received on this instance
- Distr Msgs Recv'd - total number of remote (inter-instance) messages received on this instance
|
VALUE
|
NUMBER
|
The value of the statistic
|