轉載How to read a STATSPACK Report

Oracle Tips by Burleson Consulting

Question:

  How do I read a STATSPACK report?

Answer:

 Reading a STATSPACK report can be very tricky.

The STATSPACK report is an offshoot of the old bstat-estat report, which was create for Oracle internal-use only and it is not documented by Oracle.  Many of the performance metrics are undocumented also and required detailed knowledge of Oracle internals, and reading a STATSPACK report requires considerable knowledge. 

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

Also, you can paste-in a STATSPACK report into http://www.statspackanalyzer.com  and learn how to analyze a STATSPACK report.  There are several Oracle Press books on STATSPACK, you may find useful for learning to read a STATSPACK report..

In a nutshell, the most important areas to read in any STATSPACK report are the top-5 timed events and the statistics for the major database events.  The I/O statistics are also very useful.  I have my notes on how to read a STATSPACK report here:

• Oracle STATSPACK reading Tips

• Oracle STATSPACK Analyzer

• Using STATSPACK to monitor Oracle performance

• Oracle 10g AWR script. for physical disk reads - Monitoring I/O

• Using STATSPACK to monitor Oracle performance

• Interpreting Oracle RAC STATSPACK/AWR performance reports

• Oracle AWR report

• Measuring Oracle transactions per second

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/13750068/viewspace-501492/，如需轉載，請注明出處，否則将追究法律責任。

轉載于:http://blog.itpub.net/13750068/viewspace-501492/