Help me refine this Buffer Cache Hit Ratio query!

I currently use the following query to get the raw numbers in determing the buffer cache hit ratio:

  select name, value
  from v$sysstat
  where name IN ('db block gets', 'consistent gets'     'physical reads');

Next, I manually figure the hit ratio using the following formula:

    hit ratio = 1 - (phy read / (db blk gets + consis gets) )

Can someone show me how this script could be modified to produce this hit ration value itself???

Thanks in advance. Received on Fri Aug 19 1994 - 16:18:11 CEST