Oracle诊断案例----如何捕获问题SQL解决过度CPU消耗问题[2]

 
sql> select sid,event,p1,p1text from v$session_wait;

       sid event                                  p1 p1text
---------- ------------------------------ ---------- ----------------------------------------------------------------
       124 latch free                     1.6144e+10 address
         1 pmon timer                            300 duration
         2 rdbms ipc message                     300 timeout
         3 rdbms ipc message                     300 timeout
        11 rdbms ipc message                   30000 timeout
         6 rdbms ipc message                  180000 timeout
         4 rdbms ipc message                     300 timeout
       134 rdbms ipc message                    6000 timeout
       147 rdbms ipc message                    6000 timeout
       275 rdbms ipc message                   17995 timeout
       274 rdbms ipc message                    6000 timeout

       sid event                                  p1 p1text
---------- ------------------------------ ---------- ----------------------------------------------------------------
       118 rdbms ipc message                    6000 timeout
         7 buffer busy waits                      17 file#
        56 buffer busy waits                      17 file#
       161 buffer busy waits                      17 file#
       195 buffer busy waits                      17 file#
       311 buffer busy waits                      17 file#
       314 buffer busy waits                      17 file#
       205 buffer busy waits                      17 file#
       269 buffer busy waits                      17 file#
       200 buffer busy waits                      17 file#
       164 buffer busy waits                      17 file#

       sid event                                  p1 p1text
---------- ------------------------------ ---------- ----------------------------------------------------------------
       140 buffer busy waits                      17 file#
        66 buffer busy waits                      17 file#
        10 db file sequential read                17 file#
        18 db file sequential read                17 file#
        54 db file sequential read                17 file#
        49 db file sequential read                17 file#
        48 db file sequential read                17 file#
        46 db file sequential read                17 file#
        45 db file sequential read                17 file#
        35 db file sequential read                17 file#
        30 db file sequential read                17 file#

       sid event                                  p1 p1text
---------- ------------------------------ ---------- ----------------------------------------------------------------
        29 db file sequential read                17 file#
        22 db file sequential read                17 file#
       178 db file sequential read                17 file#
       175 db file sequential read                17 file#
       171 db file sequential read                17 file#
       123 db file sequential read                17 file#
       121 db file sequential read                17 file#
       120 db file sequential read                17 file#
       117 db file sequential read                17 file#
       114 db file sequential read                17 file#
       113 db file sequential read                17 file#

       sid event                                  p1 p1text
---------- ------------------------------ ---------- ----------------------------------------------------------------
       111 db file sequential read                17 file#
       107 db file sequential read                17 file#
        80 db file sequential read                17 file#
       222 db file sequential read                17 file#
       218 db file sequential read                17 file#
       216 db file sequential read                17 file#
       213 db file sequential read                17 file#
       199 db file sequential read                17 file#
       198 db file sequential read                17 file#
       194 db file sequential read                17 file#
       192 db file sequential read                17 file#

       sid event                                  p1 p1text
---------- ------------------------------ ---------- ----------------------------------------------------------------
       188 db file sequential read                17 file#
       249 db file sequential read                17 file#
       242 db file sequential read                17 file#
       239 db file sequential read                17 file#
       236 db file sequential read                17 file#
       235 db file sequential read                17 file#
       234 db file sequential read                17 file#
       233 db file sequential read                17 file#
       230 db file sequential rea