Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: buffer hit cache ratio
Tuning by the BCHR is not done by today's top Oracle professionals. As
you've noticed, your BCHR may be "sub-optimal", i.e. less than 95% (or
whatever number you want to put in there) and yet your performance is
just fine. If you want a higher BCHR, see the following script:
http://www.oracledba.co.uk/tips/choose.htm
With it, virtually any "good" BCHR is obtained and yet application performance hasn't changed.
Today, many top Oracle professionals use the V%DB_CACHE_ADVICE view in Oracle 9i and the Oracle Wait Event interface to determine if the buffer cache is the bottleneck to performance.
HTH,
Brian
Tom Brown wrote:
>
> What is an acceptable hit ratio?
>
> currently i have about 84% and although the performance is fine i'm curious
> if i can make it better?
>
> thanks
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Mon Dec 22 2003 - 15:58:56 CST