Post date: 04-Nov-2009 13:00:21
DOC ID : 94224.1
STATSPACK FREQUENTLY ASKED QUESTIONS
------------------------------------
CONTENTS
--------
1) What is StatsPack and how does STATSPACK work? Where are StatsPack README
files? The README files contain the most up to date inforamtion about StatsPack.
See Note 149115.1: What is StatsPack and where are the READMEs?
2) How do I install StatsPack? Can StatsPack be installed with SVRMGRL?
See Note 149113.1: Installing and Configuring StatsPack Package
3) How do I take a snapshot of current database statistics? How do I capture
different levels of performance information for either the session or an
instance? How can I automate the process of capturing the StatsPack
snapshots?
See Note 149121.1: Gathering a StatsPack snapshot
4) How do I generate a performance report?
See Note 149124.1: Creating a StatsPack performance report
5) Where can I find further documentation regarding "Performance Tuning using
Statspack"?
- See Note 228913.1: Systemwide Tuning using STATSPACK Reports:
- In the Oracle Technology Network (OTN) there are several documents
on this regards. See:
http://otn.oracle.com/deploy/performance/content.html
6) How do I move my statistics from one database to a different database to
be able to run reports?
See Note 149122.1: Sharing StatsPack snapshot data between two or more databases
7) Can StatsPack snapshots and UTLBSTAT/UTLESTAT scripts be run on the same database?
See Note 149123.1: Conflicts and differences compared to UTLBSTAT/UTLESTAT
8) How do I remove StatsPack snapshots that I am no longer interested in?
This functionality is available starting with Oracle 8.1.7 using a script
called sppurge.sql located in $ORACLE_HOME/rdbms/admin.
In Oracle 8.1.6 you will need to contact Oracle Support for assistance.
9) Statspack and Version 10g:
- It is recommended you use AWR in 10g. It is not recommended that you use both AWR and statspack in 10g.
If you must use statspack and you wish to convert historical statspack data to use in 10g, then you need to run
update script file(s) referenced in $ORACLE_HOME/rdbms/admin/spdoc.txt.
See Note 394937.1: Statistics Package (STATSPACK) Guide
- Other Statspack/10g notes of interest:
Note 332889.1: Oracle Database 10g Migration/Upgrade: Known Issues and Best Practices with Self-Managing Database
Note 276103.1: PERFORMANCE TUNING USING 10g ADVISORS AND MANAGEABILITY FEATURES
Note 274436.1: How To Integrate Statspack with EM 10G