Advertisement

Statspack

  • Norbert Debes

Abstract

Statspack is a PL/SQL package that persistently stores snapshot-based performance data pertaining to a single ORACLE DBMS instance or a set of RAC instances. It is documented in the Oracle9i Database Performance Tuning Guide and Reference manual as well as in the file $ORACLE_HOME/rdbms/admin/spdoc.txt on both UNIX and Windows.1 The latter document is significantly more detailed than the Performance Tuning Guide and Reference. Due to the introduction of the Active Workload Repository in Oracle10g, Statspack documentation has been removed from the Oracle Database Performance Tuning Guide 10g Release 2 manual.

Keywords

Execution Plan Statement Text PERF Stat Oracle Error Referential Inte Grity Constraint 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Norbert Debes 2009

Authors and Affiliations

  • Norbert Debes

There are no affiliations available

Personalised recommendations