High PGA Consumption By Mmon Slaves In The Server

郑全

High PGA Consumption By Mmon Slaves In The Server (Doc ID 2700130.1)

In this Document
Symptoms
Changes
Cause
Solution
References

APPLIES TO:
Oracle Database - Enterprise Edition - Version 18.7.0.0.0 and later
Information in this document applies to any platform.
SYMPTOMS
On : 18.7.0.0.0 version, RDBMS


-- High PGA consumption by Mmon slaves in the server
-- Issue is during (KDILM background EXEcution)
CHANGES


CAUSE
Unpublished Bug 31425761 : HIGH PGA CONSUMPTION/MEMORY LEAK BY MMON SLAVE


The issue is seen with background cleanup .

There is a new feature in 12C called "Automatic Report Capturing Feature". As part of this feature, some monitoring SQLs are executed by MMON_SLAVE to identify the resource-intensive SQLs and generate the SQL Monitoring report automatically for those SQLs.




SOLUTION
The new feature "Automatic Report Capturing Feature" can be disabled to reduce the MEMORY/CPU consumption:


SQL> alter system set "_report_capture_cycle_time"=0; /* Default is 60 seconds */



NOTE: _report_capture_cycle_time=0 /* This is system modifiable with immediate */

There is no negative impact in setting the above parameter as it disables only the automatic report capturing feature introduced in 12c. It does not disable the original SQL monitoring framework. SQL monitoring can be used very well without any issues.