Re: DB Cache Hit Rate

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 01 Sep 2004 23:24:27 +1000
Message-ID: <4135cda9$0$5288$afc38c87@news.optusnet.com.au>

Fred wrote:

> It's early morning and I haven't had my usual dose of caffeine.
>
> A client is reporting their DB buffer cache is experiencing a hit rate
> of 156%. Normally, I wouldn't be alarmed by this bit of spurious data,
> but I would like to be able to explain to the customer how this might
> occur. Anyone?
>
> Fred

What formula are they using to calculate that?

It's a bit meaningless otherwise.

I've never seen a hit ratio greater than 100% except when I attempt to calculate it using mental arithmetic alone.

Regards
HJR Received on Wed Sep 01 2004 - 08:24:27 CDT

Re: DB Cache Hit Rate > 100%