Set up a friendly environment to share my understanding and ideas about Oracle / Oracle Spatial database administration, ESRI ArcSDE Geodatabase administration and UNIX (Solaris) operating system.
V$PX_PROCESS_SYSSTAT contains information about the sessions running parallel execution.
Column
Datatype
Description
STATISTIC
VARCHAR2(30)
Name of the statistic:
Servers In Use - Number of PX servers currently performing parallel operations
Servers Available - Number of PX servers available to perform parallel operations
Servers Started - Number of times the system has had to create a PX server process
Servers Shutdown - Number of times a PX server process has been shut down. A PX server process will be shut down if it has not been used recently.
If this value is large, then consider increasing the parameter. This will improve performance by avoiding the latency of PX server process creation.
Servers HWM - Maximum number of concurrent PX server processes
If this number is equal to the PARALLEL_MAX_SERVERS initialization parameter, then 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 - 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, then you should determine the cause.
Server Sessions - Total number of sessions created by all PX servers
Memory Chunks Allocated - Number of large memory chunks allocated by PX servers
Memory Chunks Freed - Number of large memory chunks freed
Memory Chunks Current - Number of large memory chunks currently being used
Memory Chunks HWM - Maximum number of concurrently allocated chunks
Buffers allocated - Number of times a message buffer has been allocated
Buffers freed - Number of times a message buffer has been freed
Buffers Current - Number of message buffers currently being used
Buffers HWM - Maximum number of concurrently allocated message buffers
I reserve the right to delete comments that are not contributing to the overall theme of the BLOG or are insulting or demeaning to anyone. The posts on this BLOG are provided "as is" with no warranties and confer no rights. The opinions expressed on this site are mine and mine alone, and do not necessarily represent those of my employer.
No comments:
Post a Comment