Re:

sony ,

statspack -- Copyright (C) Oracle Corporation 1993, 1997

Statspack fundamentally differs from the well known UTLBSTAT/UTLESTAT
tuning scripts by collecting more information, and also by storing the
performance statistics data permanently in Oracle tables, which can later be used for reporting and analysis. The data collected can be analyzed using the report provided, which includes an "instance health and load" summary page, high resource SQL statements, as well as the traditional wait events and initialization parameters.

also have a look at ORACLE_HOME/rdbms/admin/statscre.sql for more details.

i have also mailed u a document about statspack.have a look.

HTH.
Prem Khanna J.

On Tue, 04 Feb 2003 Sony kristanto wrote :
>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: oraora  oraora
  INET: oraoraora_at_rediffmail.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).