Oracle阻塞會話查詢

select INST_ID, SID, TYPE, ID1, ID2, LMODE, REQUEST, CTIME, BLOCK,
DECODE (BLOCK, 0, '', 'blocker') blocker,
DECODE (request, 0, '', 'waiter') waiter
from gv$lock where (ID1,ID2,TYPE) in
(select ID1,ID2,TYPE from gv$lock where request>0)
order by blocker;
執行結果示例如下：
INST_ID     SID TYPE        ID1        ID2 LMODE REQUEST      CTIME BLOCK BLOCKER        WAITER
------- ------- ---- ---------- ---------- ----- ------- ---------- ----- -------------- ------------
   1      70 TX        65539    2630730     6       0       2520     1 blocker
   1      86 TX        65539    2630730     0       4       1654     0                waiter

稍等一會輸入/、回車，再次執行上面的SQL，如阻塞情況不變，則確認SID =70的會話是阻塞會話

如果結果顯示no rows selected，則表示正常