My Oracle Support Banner

Error "ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT" When Running a Scheduled Summarization Project Job (Doc ID 2455429.1)

Last updated on MARCH 20, 2024

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.3.1.0 and later
Information in this document applies to any platform.

Symptoms

When running a Project Scheduled Service to Summarize a Project, after the job finishes the status shows as "Completed with errors" and the following error occurs in the <P6 EPPM home>\p6\WebAccessLogs\P6WebAccess.html file.

If a separate p6services.jar process and configuration has been set up to handle job services, the location of the file will be the <p6services.jar location>\WebAccessLogs\ directory.

Caused by: java.sql.SQLException: ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.