Re: Correct way to accuse BCHR tuning method (Was: Hit ratio)

Performance 'problems' are dependent on what the marketing department gets in the SLA.

So if your marketing guys negotiate very strict response time requirements and you dont meet them, then you have a performance problem. How do I know if my buffer cache is having any effect on that?

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, December 27, 2003 4:24 PM

> > > #2. How do you determine whether your buffer cache is sized
> > properly?
> >
> > Your application meets it's defined operational response time
> > and throughput constraints.
>
> Actually that is an interesting answer, since it doesn't answer the
question
> asked 'How do I know if my buffer cache is sized properly' but a much
better
> question which is something like 'how do I know if my application is tuned
> sufficiently?', or to borrow Gaja's CTD idea 'How do I know when to stop
> tuning?'. I don't know if other nations have hi-fi buffs (though I guess
so)
> who obsess about the quality of the interconnects, the balance of the
> turntable, the merits of the pre-amp etc etc. I imagine them as conducting
> 'tuning' enquiries along the lines of 'how do I know if my speaker cables
> are performing optimally?' when a much much better question would be 'Why
am
> I listening to Lionel Richie anyway?'. Asking the right questions is a key
> skill for DBAs it seems to me.
>
> 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).