pga_aggregate_limit when changing pga_aggregate_target
A quick note on some peculiar behavior of the pga_aggregate_limit parameter that I noticed today. The pga limit parameter parameter was introduced with Oracle 12.1.0.1 and aims to form a hard cap (although not a hard hard cap, see Frits’ blog about this) on the amount of pga memory that can be used by the…