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