潛水珽的異想世界

STATSPACK report for

DB Name         DB Id    Instance     Inst Num Release     Cluster Host
------------ ----------- ------------ -------- ----------- ------- ------------
PROD            14479032 PROD                1 9.2.0.7.0   NO      ERPDB

              Snap Id     Snap Time      Sessions Curs/Sess Comment
            --------- ------------------ -------- --------- -------------------
Begin Snap:      1975 29-Jan-07 09:19:57      392     111.8
  End Snap:      1979 29-Jan-07 11:20:13      445     112.1
   Elapsed:              120.27 (mins)

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~                                                     % Total
Event                                               Waits    Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
enqueue                                            33,631      88,689    51.95
CPU time                                                       39,409    23.09
db file sequential read                        42,456,376      20,727    12.14
PL/SQL lock timer                                     704       6,870     4.02
log file sync                                     101,498       4,493     2.63
          -------------------------------------------------------------

從top 5 wait event中我們發現,排名第1的enqueue事件,是由於交易所引發的競爭問題。