SELECT   (SELECT COUNT (1)
            FROM v$session a2
           WHERE a2.blocking_session IS NOT NULL
             AND a2.SID = a1.blocking_session) r_count,
         a1.blocking_session,
         (SELECT a2.serial#
            FROM v$session a2
           WHERE a2.SID = a1.blocking_session) blocking_serial, a1.SID,
         a1.serial#, a1.wait_class, a1.module, a1.seconds_in_wait, a1.action
    FROM v$session a1
   WHERE a1.blocking_session IS NOT NULL AND a1.blocking_session <> 1693
ORDER BY 1;  

留言

這個網誌中的熱門文章

submit request output eamil to user

Form 常用

How To Link or Join RCV_TRANSACTIONS_INTERFACE and PO_INTERFACE_ERRORS Records