Buffer hit ratio calculate
Hi,
DB version : 11.2.0.4
select * from v$sysstat where name in ('physical reads','db block gets','consistent gets')
SYS@epssuat> select * from v$sysstat where name in ('physical reads','db block gets','consistent gets','db block gets from cache','consistent gets from cache','physical reads cache');
STATISTIC# NAME CLASS VALUE STAT_ID
---------- ---------------------------------------------------------------- ---------- -------------------- ----------
84 db block gets 8 143325887 1480709069
85 db block gets from cache 8 139319837 4017839461
88 consistent gets 8 31555837774 4162191256
89 consistent gets from cache 8 30556039057 2839918855
94 physical reads 8 1193453432 2263124246
95 physical reads cache 8 102455070 4171507801
May i know which one is correct calculate for Buffer cache hit ratio % ? what is diff ?
1 - (('physical reads cache') / ('consistent gets from cache' +
'db block gets from cache')