Kiran Dalvi07 Sep, 20230 Comments38 Secs ReadORA-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; Hope it Helps! Oracle DBAShare: ORA-01830ORA-27106: system pages not available to allocate memory