AWR and Performance Tuning

Oracle 10g provides a wealth of features, and my favorite among them is AWR. AWR has come to my rescue in critical situations where our  customers face performance issues. AWR collects database performance statistics and metrics for analysis and tuning, shows the exact time spent in the database, and even saves session information Performance can […]

Read the rest of this entry »

Oracle data buffer cache and v$db_cache_advice

Today let me brief one of the Oracle9i new features, which helped me in many projects to determine optimal size of the data buffers in large databases. The new view, v$db_cache_advice, that can predict the benefit of additional data buffers in the data buffer cache. This v$db_cache_advice view shows the estimated miss rates for twenty […]

Read the rest of this entry »