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博客 ” ，链接：https://blog.itpub.net/22034023/viewspace-717931/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
