Re: Oracle slowed down

"Vladimir M. Zakharychev" <bob--nospam--_at_dynamicpsp.com> wrote in message news:e2a80d$2r8j$1_at_hypnos.nordnet.ru...
>
> "Bob Jones" <email_at_me.not> wrote in message
> news:TaZ1g.13238$4L1.2704_at_newssvr11.news.prodigy.com...
>>
>>> Ratios are mathematical normalizations that may obsure information.
>>>
>>
>> That is a big "may". In most real world cases, it does not.
>>
>
> That is an absolutely certain "may", even "will" - any aggregate will
> obscure details it was derived from and you can't get details back
> from an aggregate. BCHR, being an aggregate, obscures details,
> which are indispensable for diagnosing real world performance issues,
> and it doesn't really say anything about performance.
>

To tune buffer cache, all you need is an aggregate. After all, buffer tuning is an overall tuning. If the hit ratio is 20%, you bet it does. Received on Fri Apr 21 2006 - 19:40:42 CDT