Oracle-L: RE:

From: GL2Z/ INF DBA BENLATRECHE <kbenlatreche_at_avl.sonatrach.dz>
Date: Tue, 04 Feb 2003 05:08:56 -0800
Message-ID: <F001.00542E27.20030204050856@fatcity.com>

Thanks Mark

It's Right !

Best Regards
Kamel Benlatreche

-----Message d'origine-----

De : Mark Leith [mailto:mark_at_cool-tools.co.uk] Envoyé : mardi 4 février 2003 11:59
À : Multiple recipients of list ORACLE-L Objet : RE:

The following is a listing from an 8.1.7 database that we run here (on Windows 2000):

E:\oracle\ora81\RDBMS\ADMIN>dir /p
Volume in drive E is C:
Volume Serial Number is A4D0-5ADF

Directory of E:\oracle\ora81\RDBMS\ADMIN

...snip...

18/02/2000  13:34                1,841 spauto.sql
15/06/2000  14:21               64,492 spcpkg.sql
18/02/2000  13:34                  916 spcreate.sql
15/06/2000  14:21               31,985 spctab.sql
15/06/2000  14:21                6,623 spcusr.sql
15/06/2000  14:53               47,820 spdoc.txt
15/06/2000  14:22                  794 spdrop.sql
15/06/2000  14:21                3,732 spdtab.sql
15/06/2000  14:21                1,334 spdusr.sql
15/06/2000  14:22                7,002 sppurge.sql
12/07/2000  14:07               72,992 spreport.sql
15/06/2000  14:22                2,278 sptrunc.sql
18/02/2000  13:34                  612 spuexp.par
15/06/2000  14:22               31,122 spup816.sql

...snip...

Previous releases (AFAIK) had a prefix of "stats*.sql".

http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html (for download versions of statspack for 8.1.6 and before)

-----Original Message-----

DBA BENLATRECHE
Sent: 04 February 2003 10:59
To: Multiple recipients of list ORACLE-L

Is it available on 8.1.7/NT.
I did a check but there is no such scripts.

Best Regards
Kamel Benlatreche

-----Message d'origine-----

De : Mark Leith [mailto:mark_at_cool-tools.co.uk] Envoyé : mardi 4 février 2003 10:24
À : Multiple recipients of list ORACLE-L Objet : RE:

Sony,

Statspack is a set of PL/SQL packages and tables that are supplied by Oracle, to take snapshots of performance metrics of your Oracle database on a regular basis, or on the fly. It is used for monitoring, diagnosis and tuning.

You can find the scripts that create and manage statspack in the $ORACLE_HOME/RDBMS/Admin directory. All of the files that are related to it begin with "sp", such as spcreate.sql (which is the script that creates the user, tables and packages for the statspack "schema").

http://otn.oracle.com/deploy/performance/pdf/statspack_tuning_otn_new.pdf

http://www.osborne.com/pressroom/0072133783_press.shtml (THE book on statspack tuning)

http://www.dba-oracle.com/art_statspack.htm (Don Burleson's web site)

http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=statspack (Google is a wonderful thing).

HTH Mark

 Mark Leith             | T: +44 (0)1905 330 281
 Sales & Marketing      | F: +44 (0)870 127 5283
 Cool Tools UK Ltd      | E: mark_at_cool-tools.co.uk
===================================================
           http://www.cool-tools.co.uk
       Maximising throughput & performance

-----Original Message-----

kristanto
Sent: 04 February 2003 07:24
To: Multiple recipients of list ORACLE-L Subject:

Hi Listers,

I'm new in DBA's job. I want to ask what is 'statspack' ? does it a third party program from oracle or a script. Where I can find the information about 'statspack' ? or if it is a script would you please to share with me ? Thank you in advance for your help. Every comments and clues would be very appreciated.

Rgrds,

Sony

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Sony kristanto
INET: Sony_at_polyfincanggih.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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

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.net
--

Author: GL2Z/ INF DBA BENLATRECHE
INET: kbenlatreche_at_avl.sonatrach.dz

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

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

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