Apr 11, 2019
TOP wait event "Acknowledge Over PGA Limit" in Oracle
TOP wait event “Acknowledge Over PGA Limit” in Oracle
TOP wait event “Acknowledge Over PGA Limit” Performance issue in Oracle
Acknowledge Over PGA limit is a new wait event introduced with PGA_AGGREGATE_LIMIT in 12.1 version of Oracle Database. If process need more PGA then process has to wait if instance is using PGA near to its limit defined in PGA_AGGREGATE_LIMIT parameter. Note: This wait event can also be encountered when PGA allocation is less…
View On WordPress