Ora-04036: the PGA memory used by the instance exceeds PGA_ AGGREGATE_ LIMIT

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: