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 22.214.171.124 and later
Information in this document applies to any platform.
During datapatch execution for DB PSU, below error is faced -
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.
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