Statistics Package (ST…

-----------------------------------------------------------------------

Oracle11g Server

Release 11.1

Production

-------------------------------------------------------------------------

Copyright (c) 1993, 2007, Oracle. All rights reserved.<wbr></wbr>

Author:<wbr> Connie Dialeris Green<br> Contributors:<wbr> Cecilia Gervasio, Graham Wood, Russell Green, Patrick Tearle,<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> Harald Eri, Stefan Pommerenk, Vladimir Barriere</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

Please refer to the Oracle11g server README file in the rdbms doc directory,
for copyright, disclosure, restrictions, warrant, trademark, disclaimer,
and licensing information.<wbr> The README file is README_RDBMS.HTM.</wbr>

Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.

-------------------------------------------------------------------------

Statistics Package (STATSPACK) README (spdoc.txt)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

TABLE OF CONTENTS
-----------------

0.<wbr> Introduction and Terminology<br> 1.<wbr> Enterprise Manager (EM), Automatic Workload Repository (AWR) and Statspack<br> 2.<wbr> Statspack Configuration<br><wbr><wbr><wbr> 2.1. Database Space Requirements<br><wbr><wbr><wbr> 2.2. Installing the Tool<br><wbr><wbr><wbr> 2.3. Errors during Installation<br> 3.<wbr> Gathering data - taking a snapshot<br><wbr><wbr><wbr> 3.1. Automating Statspack Statistics Gathering<br><wbr><wbr><wbr> 3.2. Using dbms_job<br> 4.<wbr> Running the Performance reports<br><wbr><wbr><wbr> 4.1. Running the instance report<br><wbr><wbr><wbr> 4.2. Running the instance report when there are multiple instances<br><wbr><wbr><wbr> 4.3. Configuring the Instance Report<br><wbr><wbr><wbr> 4.4. Running the SQL report<br><wbr><wbr><wbr> 4.5. Running the SQL report when there are multiple instances<br><wbr><wbr><wbr> 4.6. Configuring the SQL report<br><wbr><wbr><wbr> 4.7. Gathering optimizer statistics on the PERFSTAT schema<br> 5.<wbr> Configuring the amount of data captured<br><wbr><wbr><wbr> 5.1. Snapshot Level<br><wbr><wbr><wbr> 5.2. Snapshot SQL thresholds<br><wbr><wbr><wbr> 5.3. Changing the default values for Snapshot Level and SQL Thresholds<br><wbr><wbr><wbr> 5.4. Snapshot Levels - details<br><wbr><wbr><wbr> 5.5. Specifying a Session Id<br><wbr><wbr><wbr> 5.6. Input Parameters for the SNAP and<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> MODIFY_STATSPACK_PARAMETERS procedures<br> 6.<wbr> DB time,, and Time Units used for Performance Statistics<br><wbr><wbr><wbr> 6.1.<wbr> DB time compared to Total Call Time<br><wbr><wbr><wbr> 6.2.<wbr> Time Units used for Performance Statistics<br> 7.<wbr> Event Timings<br> 8.<wbr> Managing and Sharing performance data<br><wbr><wbr><wbr> 8.1. Baselining performance data<br><wbr><wbr><wbr><wbr><wbr><wbr> 8.1.1. Input Parameters for the MAKE_BASELINE and CLEAR_BASELINE<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> procedure and function which accept Begin and End Snap Ids<br><wbr><wbr><wbr><wbr><wbr><wbr> 8.1.2. Input Parameters for the MAKE_BASELINE and CLEAR_BASELINE<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> procedure and function which accept Begin and End Dates<br><wbr><wbr><wbr> 8.2. Purging/removing unnecessary data<br><wbr><wbr><wbr><wbr><wbr><wbr> 8.2.1. Input Parameters for the PURGE procedure and function<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> which accept Begin Snap Id and End Snap Id<wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr> 8.2.2. Input Parameters for the PURGE procedure and function<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> which accept Begin Date and End Date<br><wbr><wbr><wbr><wbr><wbr><wbr> 8.2.3. Input Parameters for the PURGE procedure and function<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> which accept a single Purge Before Date<br><wbr><wbr><wbr><wbr><wbr><wbr> 8.2.4. Input Parameters for the PURGE procedure and function<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> which accept the Number of Days of data to keep<br><wbr><wbr><wbr><wbr><wbr><wbr> 8.2.5. Using sppurge.sql<br><wbr><wbr><wbr> 8.3. Removing all data<br><wbr><wbr><wbr> 8.4. Sharing data via export<br> 9.<wbr> New and Changed Features<br><wbr><wbr><wbr> 9.1. Changes between 10.2<wbr> and 11.1<br><wbr><wbr><wbr> 9.2. Changes between 10.1<wbr> and 10.2<br><wbr><wbr><wbr> 9.3. Changes between 9.2<wbr><wbr> and 10.1<br><wbr><wbr><wbr> 9.4. Changes between 9.0<wbr><wbr> and 9.2<br><wbr><wbr><wbr> 9.5. Changes between 8.1.7 and 9.0<br><wbr><wbr><wbr> 9.6. Changes between 8.1.6 and 8.1.7<br> 10. Compatibility and Upgrading from previous releases<br><wbr><wbr><wbr> 10.1. Compatibility Matrix<br><wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>