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