ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Load DWH Job Failing due to ORA-04036 / ORA-02063 errors
Article ID: 190110
Clarity PPM On Premise
Clarity PPM SaaS
Both the incremental and Full load Data Warehouse are failing continuously in our Production.
BG DWH log shows the below error when processing DWH_FIN_TRANSACTION TABLE.
CA Clarity][Oracle JDBC Driver][Oracle]ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
ORA-02063: preceding line from PPMDBLINK
PGA Memory is completely used in PPM Database causing the remote query to generate a ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT ERROR.
This indicates a memory issue on the Database server.
Release : 15.5.1
Component : CA PPM SAAS DATA WAREHOUSE
- PGA_AGGREGATE_LIMIT is too low and needs to be increased.
- ON Premise customers check with your DBA for any sessions which are using more PGA memory and are causing the issue. Wait for the sessions to finish or kill them to free up PGA Memory.
- SAAS Customers, please create a Support ticket.