statspack报告

上一篇 / 下一篇  2008-10-15 20:09:39 / 个人分类:Oracle

    今天成功地在公司装完statspack,没有任何错误,不像在宿舍会遇到前面说的问题,接下来开始研究报告所体现的意义。我测试了一下,生成了一个报告,我把报告贴上来,之后若有研究出东西再上来更新。


STATSPACK report for

Load Profile ~~~~~~~~~~~~                            Per Second       Per Transaction                                    ---------------       ---------------
                  Redo size:              1,511.85             32,371.29
              Logical reads:                 13.69                293.06
              Block changes:                  3.87                 82.94
             Physical reads:                  2.67                 57.12
            Physical writes:                  2.67                 57.12
                 User calls:                  1.98                 42.35
                     Parses:                  0.69                 14.76
                Hard parses:                  0.05                  1.06
                      Sorts:                  0.43                  9.29
                     Logons:                  0.00                  0.00
                   Executes:                  1.29                 27.71
               Transactions:                  0.05

  % Blocks changed per Read:   28.30    Recursive Call %:    60.59
 Rollback per transaction %:    0.00       Rows per Sort:   164.76

Instance Efficiency Percentages (Target 100%)      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:  100.00       Redo NoWait %:  100.00
            Buffer  Hit   %:   99.90    In-memory Sort %:   98.73
            Library Hit   %:   93.72        Soft Parse %:   92.83
         Execute to Parse %:   46.71         Latch Hit %:   99.99
Parse CPU to Parse Elapsd %:   87.50     % Non-Parse CPU:   88.89

 Shared Pool Statistics        Begin   End                                                  ------  ------
             Memory Usage %:   71.80   72.75
    % SQL with executions>1:   96.18   96.63
  % Memory for SQL w/exec>1:   84.77   88.58

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~                                                     % Total
Event                                               Waits    Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
CPU time                                                            1    61.83
control file parallel write                           118           0    13.03
direct path read                                       68           0    11.12
db file sequential read                                 5           0     3.68
log file parallel write                               115           0     2.91
                                                                                                                        -------------------------------------------------------------
Wait Events for DB: AAAAA  Instance: AAAAA  Snaps: 1 -2
-> s  - second
-> cs - centisecond -     100th of a second
-> ms - millisecond -    1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)

还是贴比较重点的部分出来~~~


TAG: Oracle

 

评分:0

我来说两句

Open Toolbar