SQL job failure with ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
Oracle version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.13.0.0.0
OS version: Linux x86_64 Red Hat 7
Standalone database, no RAC
Problem: Customer reported SQL job failure with ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
Current setting are:
pga_aggregate_limit big integer 5000M
pga_aggregate_target big integer 1250M
sga_max_size big integer 3760M
sga_min_size big integer 0
sga_target big integer 3760M
memory_max_target big integer 0
memory_target big integer 0
Questions:
- Can I keep increasing pga_aggregate_limit until the issue is resolved?
- Can I just set pga_aggregate_limit =0? What will be the impact to set pga_aggregate_limit =0?