Dennis, The Toad provides "Waits"... but there's a lot of events like "buffer busy waits","control file parallel write","control file sequential read",..... Can you point me to the correct direction or suggest some informations about how to analyse those events?
For STATSPACK, how to tell whether it's installed? and which scripts should be run in order to use it? Well....yes, i'm working for a taiwanese company, they insist to include Chinese name in signature. sorry for the inconvenience cause. and thanks for the help. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 9:38 PM > Shuan - Bumping up the memory for shared pool and database buffers may well > turn out to be the answer, but before you just jump in and make the changes > and hope for the best, why not dig into the root causes of the slowness > first? Specifically, collect information on the top wait events. I'm not > familiar with Toad, but perhaps it can provide these. My personal favorite > is STATSPACK, which comes with Oracle, but you'll have to install it. Or you > can just directly query the V$ views. If the wait statistics confirm the > need to increase these buffers, once you make the change you can measure > these statistics again and confirm that you are making a positive > improvement. > Also, does your signature have some sort of foreign language font? When > I opened your email I got an error message about that. > > > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?big5?B?c2h1YW4udGF5XChQQ0m+R7hSs9RcKQ==?= 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).