Path: text.usenetserver.com!out03a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news1.google.com!newshub.sdsu.edu!tethys.csu.net!nntp.csufresno.edu!sn-xt-sjc-03!sn-xt-sjc-06!sn-post-sjc-01!supernews.com!corp.supernews.com!not-for-mail From: sybrandb@hccnet.nl Newsgroups: comp.databases.oracle.server Subject: Re: Cache Hit Ratio from system views Date: Wed, 08 Aug 2007 21:38:00 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: References: <1186588653.996873.185140@l70g2000hse.googlegroups.com> <1186597870.627874@bubbleator.drizzle.com> <1186599766.578604.210630@q75g2000hsh.googlegroups.com> X-Newsreader: Forte Agent 4.2/32.1118 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 22 Xref: usenetserver.com comp.databases.oracle.server:432672 X-Received-Date: Wed, 08 Aug 2007 15:38:46 EDT (text.usenetserver.com) On Wed, 08 Aug 2007 12:02:46 -0700, Teresa Masino wrote: > >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). Only good old Don Burleson makes people erroneously believe they can tune their database by throwing memory at the problem to crank up the BCHR. Savy professionals (a favorite phrase of Don) know better. -- Sybrand Bakker Senior Oracle DBA