Re: Shared Pool Size

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" <ORACLE-L_at_fatcity.com> 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" <ORACLE-L_at_fatcity.com>
> 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.
> > dwilliams_at_lifetouch.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?big5?B?c2h1YW4udGF5XChQQ0m+R7hSs9RcKQ==?=
> INET: shuan.tay_at_pci.co.id
>
> 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.com
-- 
Author: Babu Nagarajan
  INET: orclbabu_at_hotmail.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).