Skip to main content
Solved

Statspack Installation


Kelum Pradeep Kumara
Superhero (Employee)
Forum|alt.badge.img+18
Is there any guide to install and manage statspacks on a customer environment to retrieve the performance information?

Best answer by Charith Epasinghe

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
View original
Did this topic help you find an answer to your question?

Charith Epasinghe
Superhero (Employee)
Forum|alt.badge.img+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

durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • March 26, 2020

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings