Day: December 28, 2020

PGA_AGGREGATE_LIMIT

The initialization parameter PGA_AGGREGATE_LIMIT has been introduced since Oracle Database 12c 12.1.0.1. It is used to put a hard limit on PGA memory usage. If PGA usage exceeds the PGA_AGGREGATE_LIMIT value defined, Oracle Database aborts or terminates the sessions or processes that are consuming the most untunable PGA memory. In Oracle 12.1.0.1, although the Oracle … Continue reading PGA_AGGREGATE_LIMIT