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