Error ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT When Running Scheduled Summarization Project Job
(Doc ID 2455429.1)
Last updated on MARCH 22, 2022
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 8.3 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 22.214.171.124 and later
Information in this document applies to any platform.
When attempting to run a Project Scheduled Service to Summarize a Project, the following error occurs.
"Completed with Errors"
Please refer to P6 Server Side Log for more information
The log file shows the following error as the reason for the failure.
Caused by: java.sql.SQLException: ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
The issue can be reproduced at will with the following steps:
1. Configure a Project Scheduled Service to run a summarize job
2. Receive error
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document