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

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

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