My Oracle Support Banner

Automated Upgrade Tool (AUT) Fails with Error "ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT" (Doc ID 2236209.1)

Last updated on AUGUST 26, 2020

Applies to:

Oracle Agile PLM Framework - Version to [Release 9.3]
Information in this document applies to any platform.


When upgrading an Agile Database (DB) using AUT it is taking very long time and the AUT log shows below error.

'ORA-04036: PGA Memory Used by the Instance Exceeds PGA_AGGREGATE_LIMIT'


In AUT.log, after a certain point, Oracle is disconnected because it reached PGA_AGGREGATE_LIMIT value. Since the database was disconnected, the AUT script was just running and nothing actually was happening ( no upgrade).

Steps to Reproduce

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

  1.  Run AUT


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

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