SGA Hit Ratios

Data Dictionary

SELECT   Parameter,SUM(getmisses), SUM(gets)
FROM   v$rowcache group by parameter

 

Buffer Cache

SELECT name,value from v$sysstat where
name in
('db block gets',
'consistent gets',
'physical reads')


Library Cache

select
   namespace,
   gets,
   gethitratio*100 gethitratio,
   pins,
   pinhitratio*100 pinhitratio,
   reloads,
   invalidations
from
   v$librarycache

Download Speedway to graphically plot the above script results.

Complete Database Performance Management