Monitoring Oracle RAM Regions

When you make global changes to Oracle you often have to aim at a one-size-fits-all setting, geared to be optimal to the majority of your users.  These global parameters include the parameters that govern the RAM regions within Oracle.

For example, when you make changes to pga_aggregate_target you need to track time-based changes in disk sorts and the number of total hash joins.  Tracking sorts is easy with an AWR report for metric (sorts (disk)), but tracking hash joins is trickier.  Read more about why tracking time-series metrics is critical for SGA and PGA tuning:

http://www.dba-oracle.com/t_monitoring_sga_pga_memory_changes.htm

For the scripts (and details on how to use them), see my book "Oracle Tuning: The Definitive Reference":

http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm

*****************************************

Need an Oracle Mentor?

Oracle cannot be learned in a vacuum, and they only way to become an Oracle guru is with the help of an experienced Oracle professional.

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call me at 800-766-1884 for details, and check-out our on-site Oracle training catalog:

http://www.dba-oracle.com/bc-catalog.pdf