How to Determine a potential Buffer Cache problem
How to Determine a potential Buffer Cache problem
SELECT size_for_estimate "Estimated Cache size (Mb)", buffers_for_estimate "Buffers", estd_physical_reads "Estimated Reads" FROM v$db_cache_advice ORDER BY 1