Datapatch faces error " ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT"
(Doc ID 2560320.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation 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.
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 |