ANKUSH THAVALI
- 07 Sep, 2023
- 0 Comments
- 38 Secs Read
ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT
ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT
Solution : 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;