Re: buffer hit cache ratio

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 23 Dec 2003 22:21:52 +0800
Message-ID: <3FE84F80.5F81@yahoo.com>

Geomancer wrote:
>
> > Tuning by the BCHR is not done by today's top Oracle professionals.
>
> Depends on who you consider a "top" professional.
>
> Tom Kyte and Cary Millsap both argue that the BHR is not a panacea,
> but is IS useful for detecting when the data buffers are way too
> small.
>
> The BHR is VERY similar to the v$db_cache_advice view.

The issue here is not the ratio but its usage...

Measuring it is fine, having a target number as some means of system performance is not.

In any event, the likelihood of anyone's formula being correct is probably nil.

hth
connor Received on Tue Dec 23 2003 - 08:21:52 CST