My Oracle Support Banner

FAQ- Statspack Complete Reference (Doc ID 94224.1)

Last updated on JANUARY 25, 2021

Applies to:

Oracle Database - Standard Edition - Version 8.1.6.0 and later
Oracle Database - Personal Edition - Version 8.1.6.0 and later
Oracle Database - Enterprise Edition - Version 8.1.6.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.

Purpose

Provide a list of  frequently asked questions and answers on STATSPACK.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 STATSPACK FREQUENTLY ASKED QUESTIONS
 How is StatsPack installed?
 How is a snapshot of current database statistics taken?
How do I capture different levels of performance information for either the session or an instance?
How can I automate the process of capturing the StatsPack snapshots?
 Where can I find further documentation regarding "Performance Tuning using Statspack"?
 How do I move my statistics from one database to a different database to be able to run reports?
 How do I remove StatsPack snapshots that I am no longer interested in?
 Is StatsPack available in Oracle 10g and higher?
 Where can I get more information on Statspack?
 Community Discussions
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.