| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE:
Hi
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 servicesto: 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).
---------------------------------------------------------------------
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 servicesto: 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).
---------------------------------------------------------------------
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 servicesto: 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). Received on Tue Feb 04 2003 - 04:58:42 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |