My Oracle Support Banner

Datapatch faces error " ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT" (Doc ID 2560320.1)

Last updated on JULY 08, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

 During datapatch execution for DB PSU, below error is faced -

Patch 29141038 apply: WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29141038/22808025/29141038_apply_<SID>_2019Jun15_04_40_13.log (errors)
Error at line 130684: ORA-00604: error occurred at recursive SQL level 1
Error at line 130685: ORA-00039: error during periodic action
Error at line 130686: ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
Error at line 134257: Warning: Package Body created with compilation errors.

 

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!


In this Document
Symptoms
Changes
Cause
Solution

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