Sample Header Ad - 728x90

My PGA getting filled up quickly in oracle 21 XE

0 votes
0 answers
71 views
I'm using Oracle 21c XE for an application with a database size of less than 0.5 GB. However, I’m encountering the error: ** ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT. I’ve tried restarting the database to release the PGA memory, but the issue reappears within a day, forcing me to restart the database daily. Upon investigation, I noticed that the process oracle@.host.secureserver.net (CJQ0) steadily increases its memory usage, eventually reaching the 2 GB limit within 24–36 hours. I currently have only two scheduled jobs, but disabling them didn’t make a significant difference. I’d appreciate any guidance or suggestions on how to resolve this issue. Thanks!
Asked by Nabeel A N (1 rep)
Jan 13, 2025, 10:09 AM