首页 > Linux操作系统 > Linux操作系统 > 转载How to read a STATSPACK Report

转载How to read a STATSPACK Report

原创 Linux操作系统 作者:yyp2009 时间:2008-11-23 16:05:24 0 删除 编辑
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 "". 


Also, you can paste-in a STATSPACK report into   and learn how to analyze a STATSPACK report.  There are several , 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:

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: 转载Oracle AWR速查
下一篇: 转载10gocp翻译
请登录后发表评论 登录


  • 博文量
  • 访问量