Re: buffer hit cache ratio

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:<3FE84F80.5F81_at_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

BAABCHR anyone care to post a page indicating such? sign me up.

Pd

(in case you don't know what this means, check out http://www.baarf.com) Received on Sat Dec 27 2003 - 19:10:17 CST