Forum Stats

  • 3,825,924 Users
  • 2,260,580 Discussions
  • 7,896,737 Comments

Discussions

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