Statspack is installed under the username "PERFSTAT". You should be able to tell if such user exists by quering the dba_users table.
There are two good articles on the Oracle Magazine on how to install and use Statspack. Search the technet.oracle.com site Babu ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 12, 2002 9:59 PM > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan 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).
