I too think the BCHR has its place, as a problem indicator. It can tell me
theres something wrong with my database. Say, I have this database
performing well, the users are happy, the BHR is mostly at 90%, and now it
suddenly shoots down to 70%, or it suddenly increases to 98. Somethings
amiss. Its less tasking, to code for scripts that query v$sysstat to
indicate me of some problems, rather than querying v$sqlarea. Or I need to
code for some intelligent scripts to query v$session_wait or
V$system_event. Or I need to look at the statspack reports every hour. The
point is when do I look at wait events? When the user calls me up?
All the papers out there, asking us rightly, to look at wait events, trash
the BCHR. I think what the authors intended was to tell us that increasing
DB_BLOCK_BUFFERS was not the solution to a low BCHR, and that a BCHR of 99%
does not mean a highly efficient database. Vice Versa, a BCHR of 50% does
not indicate a poorly performing database. Give me a database with a 45%
BHR, and I can get it to 99% by running a few queries. Point well
understood. It does not mean in any way that I should now ignore PIO's and
start tuning LIO's.
I still use BCHR. "What you infer from the BCHR is what counts".
Raj
"Yechiel
Adar" To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
<adar76@inter cc:
.net.il> Subject: Re: BCHR Tuning
Sent by:
root@fatcity.
com
January 13,
2003 10:58 AM
Please
respond to
ORACLE-L
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 <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
> 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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
