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.
KeywordsExecution Plan Statement Text PERF Stat Oracle Error Referential Inte Grity Constraint
Unable to display preview. Download preview PDF.