123
ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT
ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT1234567891011121314151617
First thing you need to check , why the session is using lot of PGA.
Then follow any of the below.
Set
PGA_AGGREGATE_LIMIT to 0
, which removes the limit on PGA usage per session.
alter system set pga_aggregate_limit=0 scope=both;
Else increase the size of PGA_AGGREGATE_LIMIT to a higher value.
alter system set pga_aggregate_limit=3072M scope=both;
Hope it Helps!