First page Back Continue Last page Overview Graphics
…Miscellaneous
STATSPACK
- Introduced with 8i, but now utlbstat/utlestat deprecated
- Get used to using statspack
- A set of SQL, PL/SQL, and SQL*Plus scripts
- More reporting flexibility
- Stores history of V$ tables
- Report on any time period within snapshot
- More comprehensive statistics
- Very little overhead
Notes:
Statspack is installed with the spcreate.sql script which can be found in the $ORACLE_HOME/rdbms/admin directory or folder. This script must be run as a SYSDBA user.