RE: Re: BCHR Tuning

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Mon, 13 Jan 2003 01:43:39 -0800
Message-ID: <F001.0052D716.20030113014339@fatcity.com>

('binary' encoding is not supported, stored as-is)
I personally find the turn the argument is taking rather dispiriting. I have, like everybody who has been working with Oracle for some time, used BCHR in the past (and queried X$KCBRBH and its twin, X$KCBCBH). To be honest, I even have had some quite interesting results - which I would get by other means today. I have later understood that buffer gets were indeed a superior yardstick - till quite recently some experiments with IOTs convinced me that in some cases you had much better results in terms of response time (what ultimately matters) with slightly more buffer gets and more physical reads than what you could achieve. We all want to close on those outrageously bad lines of code or, more subtly, that poorly thought process. There is more than one angle of approach, some people will swear by trace files, other by events and waits, others by V$SQL or simply by code review or listening to end-users ... I guess it depends on whether you are more at heart a closet SA or a cl! os!
et developer, and even in the later case whether you are a debugger artist or somebody trying to think globally; we are wired differently, all approaches may be respectable if taken with a pinch of salt. I would gladly say of Oracle tuning what my favorite author, Chamfort, says of love : "In love, everything is true, everything is false; it is the one subject on which one cannot express an absurdity."

The holy war BCHR vs anti-BCHR has a definite Swiftian smell.

My 0.02 euro.

>----- Original Message -----
>From: Jared Still <jkstill_at_cybcon.com>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Sun, 12 Jan 2003 22:08:37
>
>
>And quite a number of folks were making use of the
>v$
>stats quite some time before that with little
>regard for the BCHR,
>though maybe not officially yet ignoring the BCHR
>
>Jared
>
>
>On Sunday 12 January 2003 17:03, Anjo Kolk wrote:
>> Hmm,
>>
>> Lately? That actually started publicly in 1998 as
>far as I am concerned ;-)
>> And acutally long before that.
>>
>> Anjo.
>>
>> ----- Original Message -----
>> To: "Multiple recipients of list ORACLE-L"
><ORACLE-L_at_fatcity.com>
>> Sent: Sunday, January 12, 2003 11:43 PM
>>
>> > On Friday 10 January 2003 14:48, Mogens
>Nørgaard wrote:
>> > > Obviously, we don't know what we're talking
>about. I can see there's a
>> > > presentation by Rich Niemich at IOUG-A where
>he'll address all those
>> > > idiots who are saying you should ignore the
>Cash Hit Ratio (and who are
>> > > all just after making big money on their
>products - I loved that one).
>> > >
>> > > > Or modify the set up of these tools to take
>action when BCHR
>>
>> falls......
>>
>> > Here's the session info:
>> >
>> > Date: Mon, Apr 28, 2003 @ 11:45 AM - 12:15 PM
>> > Venue: Southern Hemisphere 2, Walt Disney World
>
>> > Dolphin, Lake Buena Vista, FL
>> >
>> > Abstract: Lately, there has been a big push to
>ignore your
>> > hit ratio with claims that it is meaningless.
>This shallow
>> > minded view (usually by people who sell a
>tuning tool) ignores
>> > why people look at hit ratios and what they are
>looking for.
>> > This quick tip talk will show you what to look
>for and why.
>> > You will definitely know when, where & why to
>look at your
>> > hit ratio in the future.
>> >
>> > Show you why your hit ratio matters. How to
>analyze the
>> > hit ratio. Fallacies by those who want to sell
>you products
>> > and tools instead.
>> >
>> >
>> > Shallow Minded ?!
>> >
>> > Jared
>> > --
>> > Please see the official ORACLE-L FAQ:
>http://www.orafaq.net
>> > --
>> > Author: Jared Still
>> > INET: jkstill_at_cybcon.com
>> >
>> > Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>> > San Diego, California -- Mailing list
>and web hosting services
>> >
>> > To REMOVE yourself from this mailing list, send
>an E-Mail message
>> > to: ListGuru_at_fatcity.com (note EXACT spelling
>of 'ListGuru') and in
>> > the message BODY, include a line containing:
>UNSUB ORACLE-L
>> > (or the name of mailing list you want to be
>removed from). You may
>> > also send the HELP command for other
>information (like subscribing).
>--
>Please see the official ORACLE-L FAQ:
>http://www.orafaq.net
>--
>Author: Jared Still
> INET: jkstill_at_cybcon.com
>
>Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>San Diego, California -- Mailing list and
>web hosting services
>To REMOVE yourself from this mailing list, send an
>E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of
>'ListGuru') and in
>the message BODY, include a line containing: UNSUB
>ORACLE-L
>(or the name of mailing list you want to be removed
>from). You may
>also send the HELP command for other information
>(like subscribing).
>---------------------------------------------------
>------------------
>---------------------------------------------------
>------------------

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroul
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jan 13 2003 - 03:43:39 CST