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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2009 Norbert Debes
About this chapter
Cite this chapter
Debes, N. (2009). Statspack. In: Secrets of the Oracle Database. Apress. https://doi.org/10.1007/978-1-4302-1953-8_25
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1953-8_25
Publisher Name: Apress
Print ISBN: 978-1-4302-1952-1
Online ISBN: 978-1-4302-1953-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books