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" <[EMAIL PROTECTED]> 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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).