STATISTIC |
VARCHAR2(30) |
The name of the statistic: |
|
|
|
|
|
- Servers HWM: The maximum number of concurrent PX server processes
If this number is equal to the initialization parameter PARALLEL_MAX_SERVERS, consider increasing the parameter. This could allow you to increase your throughput, especially if your system is under-utilized and the V$SYSSTAT statistic "Parallel operations downgraded to serial" is large
- Servers Cleaned Up: The number of times PMON had to clean up a PX server. This should only happen during abnormal termination of a parallel operation
If this number is large, it is recommended that the cause be determined |
|
|
- Sessions: The total number of sessions created by all PX servers
- Memory Chunks Allocs: The number of large memory chunks allocated by PX servers
- Memory Chunks Freed: The number of large memory chunks freed
- Memory Chunks Current: The number of large memory chunks currently being used
- Memory Chunks HWM: The maximum number of concurrently allocated chunks
|
|
|
- Buffers allocated: The number of times a message buffer has been allocated
- Buffers freed: The number of times a message buffer has been freed
- Buffers Current: The number of message buffers currently being used
- Buffers HWM: The maximum number of concurrently allocated message buffers
|
VALUE |
NUMBER |
The value of the statistic |