Q
Problem solve Get help with specific problems with your technologies, process and projects.

Understanding a STATSPACK report

How do I understand a complete STATSPACK report?

How do I understand a complete STATSPACK report?
The STATSPACK report is an offshoot of the old bstat-estat report, which was created for Oracle internal-use only and is not documented by Oracle. Many of the performance metrics are also undocumented and require detailed knowledge of Oracle internals.

Understanding all the sections of a STATSPACK report is quite complicated, and I have a whole chapter dedicated to reading a STATSPACK (and AWR) report in my new book, Oracle Tuning: The Definitive Reference.

In a nutshell, the most important areas of the STATSPACK report are the top-5 timed events and the statistics for the major database events. The I/O statistics are also very useful.

Dig Deeper on Oracle database performance problems and tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close