Database Memory & 4030/4031 (MOSC)

MOSC Banner

SQL job failure with ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

edited Jan 12, 2022 11:01PM in Database Memory & 4030/4031 (MOSC) 7 commentsAnswered

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:

  1. Can I keep increasing pga_aggregate_limit until the issue is resolved?
  2. Can I just set pga_aggregate_limit =0? What will be the impact to set pga_aggregate_limit =0?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center