pga Archives - Exitas

pga_aggregate_limit when changing pga_aggregate_target

Jun152017Freek D'Hoogeoracle, pga, pga_aggregate_limit

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…

Handy Oracle support notes

Mar032017Pablo Hendrickx12c, buffer cache, cloud, data appliance, database, Exadata, explain plan, linux, materialized views, migration, oda, opatch, ORA-07445, oracle, parallel, parallel query, parameter, partitioning, patching, pga, pga_aggregate_limit, PSU, rac, security, storage, support, upgrade

Sometimes you just need one or more MOS / Oracle support notes quickly... Don't worry, we've got your back. We created a list of useful notes which we ourselves use every day. If you are already logged in to My Oracle Support you will immediately be redirected to the note. We are constantly updating this...

Tag: pga

pga_aggregate_limit when changing pga_aggregate_target

Handy Oracle support notes