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

    2 replies

    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
    - Charith Epasinghe
    Yasas Kasthuriarachchi
    durette
    2 people like this
    • Yasas Kasthuriarachchi
      Yasas Kasthuriarachchi
    • durette
      durette
    durette
    Superhero (Customer)
    Forum|alt.badge.img+19
    • durette
    • Superhero (Customer)
    • 529 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

    Reply


    Terms & ConditionsCookie settings

    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