Roy,
If you are running Oracle 8i, you might want to check out the
STATSPACK package and its functionality. It is the replacement
for utlbstat/estat and provides significantly more relevant
information. For more information about STATSPACK visit the
Oracle Technology Network at
http://technet.oracle.com/deploy/performance and the
documentation that is supplied with Oracle release 8.1.6 –
statspack.doc. This file is also located in the
$ORACLE_HOME/rdbms/admin directory.
Cheers,
Gaja
- Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
wrote:
> Oracle's utility...
>
> BSTAT/ESTAT
>
> do a search on *bstat* on your file system in the oracle home
> directory.
>
> Regards,
> Satar
>
> > -----Original Message-----
> > From: Roy Ferguson [SMTP:rferguso_at_level1.com]
> > Sent: Tuesday, November 07, 2000 9:56 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Performance tuning
> >
> >
> > can I get some feedback from dba's out there have have a top
> 10 or so list
> > of
> > things they regularly look for when doing performance
> tuning?...what
> > things do
> > you look at or for to determine the overall status of a
> database?
> >
> > thanks in advance...roy
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Roy Ferguson
> > INET: rferguso_at_level1.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> >
>
> > 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).
>
Gaja Krishna Vaidyanatha
Director, Storage Management Products, Quest Software Inc.
Office : (972)-304-1170, E-mail : gajav_at_yahoo.com
Author - Oracle Tuning 101 by Osborne McGraw-Hill
"Opinions and views expressed are my own and not of Quest"
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place.
Received on Tue Nov 07 2000 - 20:06:15 CST
