LLI Wiki — My Digital Knowledge Base

Oracle: install and configure Statspack

What Statspack is and a link to an install and configuration guide.

Statspack is Oracle's free tool, shipped with the database, for collecting performance statistics snapshots and producing reports that compare two snapshots. It is notably used on editions where AWR is not available.

A detailed installation and configuration guide is available here: Installing and Configuring Statspack.

The Statspack scripts are in the rdbms/admin directory of ORACLE_HOME (notably spcreate.sql to create the schema and spreport.sql to generate a report between two snapshots).

Mastodon LLIMastodon SocialFosstodon