Ensure optimal oracle process monitoring.
The PGA (Program or Process Global Area) is a memory area that stores data and control information for a single process. For example, it typically contains a sort area, hash area, session cursor cache, etc.
As the workloads change, memory is redistributed to ensure optimal performance. Applications Manager helps you in tracking the number of Oracle processes using PGA and the resouce limit for processes giving you insight on how loaded your Oracle Database is. This lets you determine how to distribute memory optimally among the components. You can view historical information about dynamic PGA memory usage by named component categories for each process as well as the used, allocated and freeable PGA(MB)
Some of the metrics for PGA management are as follows.
The tool offers complete and unified visibility into our environment and helps us identify and resolve potential performance issues quickly.
