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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] =================================================== 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: [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.net -- Author: Mark Leith 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.net -- Author: GL2Z/ INF DBA BENLATRECHE 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).
