Skip to main content
Solved

Statspack Installation

  • October 1, 2019
  • 2 replies
  • 229 views
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
-Kelum Niranjana

    2 replies

    Charith Epasinghe
    Superhero (Employee)
    Forum|alt.badge.img+13
    • Charith Epasinghe
    • Superhero (Employee)
    • 93 replies
    • Answer
    • October 1, 2019
    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
    - Charith Epasinghe
    durette
    Superhero (Customer)
    Forum|alt.badge.img+19
    • durette
    • Superhero (Customer)
    • 542 replies
    • 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.

    If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette


    Terms & ConditionsCookie settingsAccessibility statement