ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT in the application logs or when running Jaspersoft reports

Document ID : KB000124477
Last Modified Date : 14/01/2019
Show Technical Document Details
Question:
I am getting the error message:
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
in PPM logs or Jaspersoft reports.
What to do?
 
Answer:
This is a database error.
DBA should review the database configuration and see if there is a need to increase the PGA_AGGREGATE_LIMIT.
 
If the limit is big enough, then DBA should look for a query that takes on the PGA usage. If they find one, they should tune the execution plan.