Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Cache Hit Ratio from system views

Re: Cache Hit Ratio from system views

From: Bob Jones <email_at_me.not>
Date: Fri, 10 Aug 2007 01:59:52 GMT
Message-ID: <sEPui.56873$5j1.43159@newssvr21.news.prodigy.net>


>>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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US