Simply try out below oracle commands exist onside the oracle home to manage Statspack.



Installing statspack

$ORACLE_HOME/rdbms/admin/spcreate.sql



Automatic statistics gathering

$ORACLE_HOME/rdbms/admin/spauto.sql



Staspack PURGE

$ORACLE_HOME/rdbms/admin/sppurge.sql



Staspack DROP

$ORACLE_HOME/rdbms/admin/spdrop.sql



Generate Statspack reports

$ORACLE_HOME/rdbms/admin/spreport.sql

Instant Snaps - exec statspack.snap

---

If you want to know a lot more, I heard a rumor that STATSPACK was derived from code Don Burleson published in an Oracle magazine a hundred years ago, so in that sense, the book “Oracle High-Performance Tuning with STATSPACK” is straight from the horse’s mouth. It’s very cheap right now because it’s ancient.

---