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';
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
------- ------------------------- ------------- ---------------- ---- ----------
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22034023/viewspace-717931/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22034023/viewspace-717931/