EXPERT RESPONSE
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.
|
