Performance Tuning

Time Series Monitoring of the Data Buffers

http://www.praetoriate.com/t_v$buffer_pool_statistics.htm

select name, set_msize, db_block_gets, consistent_gets, physical_reads,

(1-(physical_reads/ decode(db_block_gets+consistent_gets, 0, .001, db_block_gets+consistent_gets)))*100 cache_hit_ratio

from v$buffer_pool_statistics