Day: December 28, 2020


The initialization parameter PGA_AGGREGATE_LIMIT has been introduced since Oracle Database 12c 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, although the Oracle … Continue reading PGA_AGGREGATE_LIMIT