日期:2014-05-16  浏览次数:20522 次

oracle Statspack 报告解析之 Load Profile
该部分提供每秒和每个事物的统计信息,是监控系统吞吐量和负载变化的重要部分。

Load Profile 

~~~~~~~~~~~~ 

Load Profile                            Per Second       Per Transaction

~~~~~~~~~~~~                       ---------------       ---------------

                  Redo size:            120,578.86                920.11

              Logical reads:              2,840.52                  21.68

              Block changes:                497.00                   3.79

             Physical reads:                 13.52                     0.10

            Physical writes:                  7.14                       0.05

                 User calls:                421.10                        3.21

                     Parses:                299.52                        2.29

                Hard parses:               20.19                        0.15

                      Sorts:                194.52                          1.48

                     Logons:                  1.43