Home -> Programs List page throws ORA-04036

Products

• Clarity PPM On Premise

Issue/Introduction

There are greater than 2000 sub-projects. While accessing them from the Program list page, the following error message is logged, in the app-ca.log:

ERROR 2018-10-17 15:57:34,001 [http-nio-6001-exec-14] niku.xql2 (clarity:<user>:<session>:projmgr.programs) Exception in processing 
java.lang.Exception: Invalid expression qprogramSums:
com.niku.union.persistence.PersistenceException: 
SQL error code: 4036
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

Cause

In Oracle Database, a parameter called PGA_AGGREGATE_LIMIT sets a hard limit on the amount of PGA taken up by an instance. When the overall PGA occupied by all the sessions in that instance exceed the limit, Oracle kills the session holding the most PGA memory, releasing all PGA memory held by that session. This happens when doing Manual Memory Management (MMM).

Resolution

In order to overcome this error, review the Oracle AWR report and adjust the PGA allocation, refer Oracle documentation for the same.