Re: Oracle slowed down

From: Bob Jones <email_at_me.not>
Date: Sat, 22 Apr 2006 02:28:21 GMT
Message-ID: <9xg2g.4680$Lm5.1016@newssvr12.news.prodigy.com>

"HansF" <News.Hans_at_telus.net> wrote in message news:pan.2006.04.22.01.32.46.787609_at_telus.net...
> On Sat, 22 Apr 2006 01:05:09 +0000, Bob Jones wrote:
>
>>>
>>> A 100% BCHR can just as easily identify a grossly overconfigured cache
>>> as it can identify popular data sets. In both cases the
>>> misinterpretation is that it looks good.
>>>
>>>
>> That's why we need to tune the buffer cache.
>
> Tuning BCHR is NOT tuning buffer cache.
>
> Buffer Cache is important, not BCHR.
>
> <sigh>
>

No, you do not tune BCHR. It's only there to help you tune buffer cache. How do you know buffer cache needs tuning without looking at BHCR? Received on Fri Apr 21 2006 - 21:28:21 CDT