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)
Oracle Process Monitoring Metrics:
Some of the metrics for PGA management are as follows.
- PGA used
- Total PGA allocated
- Maximum PGA allocated
- Total freeable PGA
- PGA freed back to OS
- Cache hit percentage
- Resource being used by processes