Message from discussion
Cache Hit Ratio from system views
Path: g2news2.google.com!news2.google.com!news.glorb.com!newshub.sdsu.edu!newscon04.news.prodigy.net!prodigy.net!newsdst01.news.prodigy.net!prodigy.com!postmaster.news.prodigy.com!newssvr11.news.prodigy.net.POSTED!73fe1710!not-for-mail
From: "Bob Jones" <em...@me.not>
Newsgroups: comp.databases.oracle.server
References: <1186588653.996873.185140@l70g2000hse.googlegroups.com> <1186597870.627874@bubbleator.drizzle.com> <1186599766.578604.210630@q75g2000hsh.googlegroups.com> <nk6kb35l9bpv0mhlpl6bn9f1e1dja3esc8@4ax.com> <sEPui.56873$5j1.43159@newssvr21.news.prodigy.net> <q7tnb3h6duhe3apub6iieqv76rrpea4ehk@4ax.com>
Subject: Re: Cache Hit Ratio from system views
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
Message-ID: <jO8vi.27305$RX.26761@newssvr11.news.prodigy.net>
NNTP-Posting-Host: 75.27.179.120
X-Complaints-To: abuse@prodigy.net
X-Trace: newssvr11.news.prodigy.net 1186797839 ST000 75.27.179.120 (Fri, 10 Aug 2007 22:03:59 EDT)
NNTP-Posting-Date: Fri, 10 Aug 2007 22:03:59 EDT
Organization: SBC http://yahoo.sbc.com
X-UserInfo1: Q[R_@SVG\RU]BQYXOJHD]_\@VR]^@B@MCPWZKB]MPXHZUYICD^RAQBKZQTZTX\_I[^G_KGFNON[ZOE_AZNVO^\XGGNTCIRPIJH[@RQKBXLRZ@CD^HKANYVW@RLGEZEJN@\_WZJBNZYYKVIOR]T]MNMG_Z[YVWSCH_Q[GPC_A@CARQVXDSDA^M]@DRVUM@RBM
Date: Sat, 11 Aug 2007 02:03:59 GMT
>>>>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.
>>
>
> Assuming you are such a 'savy professional' 'Mr' Jones, why didn't you
> notice throwing memory at the problem doesn't help?
It can help sometimes. But what does that have to do with anything?
> On another note: If you think *you* know better, why don't you
> contribute a *working* example of the Burleson strategy?
Did I say anything about his strategy? Yet another assumption.
> You have a track record of lurking and only chiming in when you can
> flame someone with the drivel like you posted above.
I clearly disagree with the statement that BHCR is meaningless. This has
been discussed several times before. I won't waste any more energy.
> I recall your flame wars with Daniel Morgan, which only served to
> establish *you* are NOT a 'savy professional' but just some *arrogant
> idiot* (of which we have already way too many here).
>
What did we discuss? Was I wrong? I have no interest in becoming what you
call a "savy professional", because that really amount to exactly, an
arrogant idiot.