Best answer by Charith Epasinghe
View originalStatspack Installation
Is there any guide to install and manage statspacks on a customer environment to retrieve the performance information?
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.
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
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.