ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH 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.
  1. Set PGA_AGGREGATE_LIMIT to 0 , which removes the limit on PGA usage per session.
    alter system set pga_aggregate_limit=0 scope=both;
  2. Else increase the size of PGA_AGGREGATE_LIMIT to a higher value.
    alter system set pga_aggregate_limit=3072M scope=both;
    

Hope it Helps!