9i,enqueue,ORACLE鎖爭用 檢視爭用型別

select sid, event, p1, p1raw,
chr(bitand(P1,-16777216)/16777215)||chr(bitand(P1,16711680)/65535) type,
mod(P1, 16) "MODE"
from   v$session_wait
where  event = 'enqueue';

 

記錄在此，總是找指令碼找半天

 

SID EVENT                                P1 P1RAW            TYPE       MODE
------- ------------------------- ------------- ---------------- ---- ----------
     82 enqueue                      1397817350 0000000053510006 SQ            6
    509 enqueue                      1397817350 0000000053510006 SQ            6
    651 enqueue                      1397817350 0000000053510006 SQ            6
    837 enqueue                      1397817350 0000000053510006 SQ            6

 

看到都是sequence爭用引起的'enqueue