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 MAY 01, 2023

Applies to:

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


1.  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.


2.  Error may occur when importing XML files.

  1. Login to P6 Pro.
  2. Go to File > Import.
  3. Use the import Wizard to import to Primavera P6 - (XML).
  4. Import fails.
  5. Error found in the Import Log file.


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.