Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson Consulting

Adjusting the pga_aggregate_target parameter

We may want to dynamically change the pga_aggregate_target parameter when any one of the following conditions are true:

* Whenever the value of the v$sysstat statistic “estimated PGA memory for one-pass” exceeds pga_aggregate_target, then we want to increase pga_aggregate_target.
* Whenever the value of the v$sysstat statistic “workarea executions – multipass” is greater than 1%, the database may benefit from additional RAM memory.
* You may over-allocate PGA memory, and you may consider reducing the value of pga_aggregate_target whenever the value of the v$sysstat row “workarea executions – optimal” consistently measures 100%.

The above is an excerpt from the "Oracle UNIX Administration Handbook" by Oracle press, authored by Donald K. Burleson.

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA