Re: Cache Hit Ratio?

Satar:

Perhaps this script will be useful:

col global_name for A20
variable d number
variable c number
variable r number
begin
select value into :c from v$sysstat
where name = 'consistent gets';
select value into :d from v$sysstat
where name = 'db block gets';
select ( 1- value/( :c + :d)) into :r
from v$sysstat where name in ( 'physical reads'); end;
/
select global_name, :r "Hit Ratio" from global_name;

I had this script in my old notes, so have fun with it. Received on Thu Aug 28 1997 - 00:00:00 CDT