Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
ORA-04036: PGA memory used by the instance
Hello,
I have Installed 19c (19.3.0.0)windows on my test environment, for bigger query it is not giving output.. keeps on running and PGA keeps on increasing. PGA_AGGREGATE_LIMIT was 7G. Tried to increase PGA_AGGREGATE_LIMIT to 12G, then it crosses 12g & sessions throws error.
Then tried to set PGA_AGGREGATE_LIMIT=0, then it utilizes full memory & again killed the session with "instance exceeds pga_aggrate_limit native error ,ORA-04036: PGA memory used by the instance".
Oracle version :19.12.0.0
Server- Windows 2019, memory 16G
Earlier Installed 19.3 and to fix the bugs upgraded to 19.12 based on Bug 27933036 - pga memory leak (Doc ID 27933036.8). Still the issue is not getting fixed.
Anyone can help on this ?
Answers
-
Hello,
did you check AWR report and v$pgastat?
Regards,
Roshan
-
Thanks for the response, it is fixed by changing optimizer_features_enable to an older version.