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 »