My Oracle Support Banner

Error 'ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT' When Performing Global Search and Replace with Project Owner (Doc ID 2702461.1)

Last updated on AUGUST 27, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 19.12.5.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to use global search and replace with project owner, the following error occurs in the P6WebAccess.html log file:

ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

 

The issue can be reproduced at will using the following steps:

  1. Log into P6 Web.
  2. Navigate to Projects > EPS.
  3. Click Actions > Global search and replace.
  4. Select User or Global Template.
  5. Select the EPS in the left column and click the arrow to move it to the right column, then click Next.
  6. Define the search criteria.
  7. Project owner = "specify value".
  8. Define the replace criteria.
  9. Project owner = <a new value>.
  10. Click Apply.
  11. View the reported error in the log file.

Changes

 

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.