#1. what is the difference in the 4 BCHR's in 9i?
#2. How do you determine whether your buffer cache is sized properly?
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Saturday, December 27, 2003 9:34 AM
> Hi Yong
> > I agree that "It's not the ratio that needs condemning, it's
> > the advice about..." What I disagree is the wrong educational
> > tool people on public forums have recently used again and
> > again to show the inadequacy of the BCHR tuning method.
>
> The thing is most people who have used this demonstration, use it for 2
> reasons
>
> 1. It is immediately recognised and empathised with by the audience and
> 2. It is easily explained. "How does it work, by doing pointless io, hmmm
I
> wonder if that is a problem with my real system."
>
> You are of course in principle correct that one could use the same
technique
> against other ratios, my suggestion would be that this might also be
> appropriate for similar reasons. My CPU is 75% utilized on my web server,
I
> wonder does this mean it is well specified or that I am doing pointless
cpu
> work?
>
> If people are merely saying "the bchr is useless, here is a script that
will
> create one for you" then I would agree with you, but in my experience the
> argument is more cogent than that.
>
> Niall
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Niall Litchfield
> INET: niall.litchfield_at_dial.pipex.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: Ryan
INET: ryan_oracle_at_cox.net
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 Sat Dec 27 2003 - 09:44:25 CST
