Resolving ORA-04036 Error During Oracle Patching

During patching the Oracle database, we are facing the PGA_AGGREGATE_LIMIT error in our database, which indicates that the total size of the Program Global Area (PGA) has exceeded the allocated limit. This issue may arise due to various factors, including insufficient memory allocation, increased workload during the patching process, or poorly optimized queries consuming excessive resources.

To address this challenge effectively, we must analyze the current memory settings, review the resource demands of active sessions, and consider adjusting the PGA_AGGREGATE_LIMIT parameter accordingly, ensuring that our database operates smoothly while implementing necessary updates.

Error: While datapatch execution, getting below error:

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.

Solution: Disable the parameter

ALTER SYSTEM SET PGA_AGGREGATE_LIMIT= 0 

Restart the patching datapatch command:

datapatch -verbose