What are the down sides of setting PGA_AGGREGATE_LIMIT to no limit, i.e. 0?
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