Re: BCHR Tuning

Hello Anjo

I just had a tuning session with Dov Hit, from ACS in Israel. He used some of the scripts that you showed him 2 years ago when you did some work for Amdocs.
Anyway, after doing some search on the waits, he checked the BCHR and found out that this database has only 40%. That led us on further checks and we found more offending SQL's.

The BCHR has it's place.
Just do not measure yourself JUST by it.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, January 13, 2003 3:03 AM

> 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: Anjo Kolk
> INET: anjo_at_oraperf.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: Yechiel Adar
  INET: adar76_at_inter.net.il

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