PGA_AGGREGATE_LIMIT

One of our 12c database hitting this message at alertlog ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT of 1024 MB PGA_AGGREGATE_LIMIT parameter comes with 12c, it sets a hard limit on the amount of PGA taken up by an instance. Program Global Area (PGA) is Continue reading