Re: Buffer Hit Ratio

From: Verma <ranju-ravi_at_worldnet.att.net>
Date: 11 Jun 1999 18:19:34 GMT
Message-ID: <01beb437$484c1820$14694e0c@Verma.medco.com>

This works fine, but with a small correction :

select (1-(sum(decode(name, 'physical reads', value,0))/

	 (sum(decode(name, 'db block gets', value,0)) +
	 (sum(decode(name, 'consistent gets', value,0)))))  ) * 100
	 "Buffer Hit Ratio"

from v$sysstat;

Thanks

plpm_at_my-deja.com wrote in article <7jl7km$dpu$1_at_nnrp1.deja.com>...
> Try this:
>
> select 1-(sum(decode(name, 'physical reads', value,0))/
> (sum(decode(name, 'db block gets', value,0)) +
> (sum(decode(name, 'consistent gets', value,0))))) * 100
> "Buffer Hit Ratio"
> from v$sysstat;
>
> It's the sentence I use normally.
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>
Received on Fri Jun 11 1999 - 13:19:34 CDT