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

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