Buffer Hit Ratio

Hi All,
What is the best SQL to determine Buffer Cache Hit Ratio?

I have the following scritps(orasnap), but I'm not convinced, because t= here
are several scritps?

select sum(decode(NAME, 'consistent gets',VALUE, 0)) "consistent gets= ",

         sum(decode(NAME, 'db block gets',VALUE, 0)) "db block gets",=

         sum(decode(NAME, 'physical reads',VALUE, 0)) "physical reads"= ,

         round((sum(decode(name, 'consistent gets',value, 0)) +
            sum(decode(name, 'db block gets',value, 0)) -
            sum(decode(name, 'physical reads',value, 0))) /
         (sum(decode(name, 'consistent gets',value, 0)) +
         sum(decode(name, 'db block gets',value, 0))) * 100,2) "Hit Rat=
io"
from     sys.v_$sysstat

Please correct me if I am wrong. Thanks for your opinion ...

Regards,
Leonardo Fern=E1ndez= Received on Fri Oct 20 2000 - 16:33:21 CDT