Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cache Hit Ratio from system views
>>Alone, yea, but they can sometimes be an indicator that an instance
>>needs attention.
> Do you really think so? Yesterday I had a customer spouting flames
> because of a RAC database coming down to a crawl due to buffer busy
> waits in conjunction with both instances updating the same table over
> and over again.
> Nothing to be seen from the BCHR.
>
> But then of course BCHR is a MIPS (Meaningless Indicator of the
> Performance of the System).
> Savy professionals (a favorite phrase of Don) know better.
>
That is a common mistake of "savy professionals" - overlooking the basics and thinking they know better. Received on Thu Aug 09 2007 - 20:59:52 CDT
![]() |
![]() |