Database Administration (MOSC)

MOSC Banner

What are the down sides of setting PGA_AGGREGATE_LIMIT to no limit, i.e. 0?

edited Feb 9, 2024 9:14PM in Database Administration (MOSC) 2 commentsAnswered ✓

hi,

What are the down sides of setting PGA_AGGREGATE_LIMIT to no limit, i.e. 0?

I'm sure there are some reasons to set upper limit. What are some main advantages!

I think I'm missing something in my logic.


I'm using SGA_TARGET for my database, it's 40G.

The PGA_AGGREGATE_TARGET is 10G

The PGA_AGGREGATE_LIMIT is 20G


I'm using RAC and Non-RAC databases, Oracle 19c database 19.4.0.0.0 and Linux 7.9

Thank you

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