Cause Java.sql.sqlexception: ora-00039: error during periodic operation
Ora-04036: the PGA memory used by the instance exceeds PGA_ AGGREGATE_ LIMIT;
uncategorized SQLException; SQL state [99999]; error code [39];
A: the error should be caused by the response service process processing operations that consume large memory, such as sort not used or group by, and the memory usage of the PGA area of the response process exceeds the database setting limit.
It can be solved through the following ideas:
1. Increase parameters PGA_ AGGREGATE_ Limit value
2. Tune the corresponding SQL to reduce the size of the corresponding mediation result set
Similar Posts:
- NPM Command Error: Allocation failed – JavaScript heap out of memory
- [Solved] CDH6.3.2 Hive on spark Error: is running beyond physical memory limits
- eclipse.ini/myeclipse.ini -Xms，-Xmx，-PerSize
- PHP: POST Content-Length of xxx bytes exceeds the limit of 8388608 bytes
- tomcat PermGen space
- How to Solve JAVA Error: “Too small initial heap”
- Zabbix unreachable poller processes more than 75% busy
- [Solved] MYSQL error 3100:error on observer while running replication hook berfore_commit
- odoo Wkhtmltopdf failed (error code: -11). Memory limit too low or maximum file number of subprocess reached. Message : b”
- MYSQL Error: Out of sort memory, consider increasing server sort buffer size; nested exception is java.sql.SQLException: Out of sort memory, consider increasing server sort buffer size