Re: Buffer Hit Ratio

I don't know whats going wrong with the code ... use the following to calculate the buffer hit ratio:

select (1 - (phy.value /( cur.value + con.value ))) * 100 hit_ratio from v$sysstat cur, v$sysstat con, v$sysstat phy where cur.name = 'db block gets' and
con.name = 'consistent gets' and
phy.name = 'physical reads'
/

Sebastian

Verma wrote:

> Any clue what is going wrong ?
Received on Wed Jun 09 1999 - 03:18:42 CDT