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
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: 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).