Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newspump.monmouth.com!newspeer.monmouth.com!newsfeed2.telusplanet.net!newsfeed.telusplanet.net!newsfeed.telus.net!clgrps12.POSTED!53ab2750!not-for-mail
From: hans <hansF@telus.net>
Subject: Re: Oracle slowed down
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2006.04.21.04.59.24.547000@telus.net>
Newsgroups: comp.databases.oracle.server
References: <e25jd2$anb$1@reader01.singnet.com.sg> <LUy1g.61712$F_3.40854@newssvr29.news.prodigy.net> <1145489802.204935@yasure.drizzle.com> <aUC1g.61766$F_3.8026@newssvr29.news.prodigy.net> <1145557619.596258@yasure.drizzle.com> <lwX1g.4480$Lm5.2796@newssvr12.news.prodigy.com> <pan.2006.04.21.02.14.20.634587@telus.net> <YcY1g.4490$Lm5.4404@newssvr12.news.prodigy.com> <pan.2006.04.21.03.36.49.265000@telus.net> <TaZ1g.13238$4L1.2704@newssvr11.news.prodigy.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Lines: 11
Date: Fri, 21 Apr 2006 04:58:17 GMT
NNTP-Posting-Host: 161.184.143.25
X-Trace: clgrps12 1145595497 161.184.143.25 (Thu, 20 Apr 2006 22:58:17 MDT)
NNTP-Posting-Date: Thu, 20 Apr 2006 22:58:17 MDT
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:266024

On Fri, 21 Apr 2006 04:27:31 +0000, Bob Jones wrote:


> Hit ratio is not meant to tell you whether application is tuned. It simply 
> shows hits verses misses. With everything else being equal, hit ratio is 
> very relevant to buffer cache.

Please explain how this is relevant to buffer cache?

Or, more importantly ...  What does the BCHR actually mean in terms of
performance?