查看锁 哪个绘画阻塞了哪个绘画
select /*+no_merge(a) no_merge(b)*/
(select username from v$session where sid = a.sid) blocker,
a.sid,
'is blocking',
(select username from v$session where sid = b.sid) blockee,
b.sid
from v$lock a, v$lock b
where a.block = 1
and b.request > 0
and a.id1 = b.ID1
and a.id2 = b.id2
select /*+no_merge(a) no_merge(b)*/
(select username from v$session where sid = a.sid) blocker,
a.sid,
'is blocking',
(select username from v$session where sid = b.sid) blockee,
b.sid
from v$lock a, v$lock b
where a.block = 1
and b.request > 0
and a.id1 = b.ID1
and a.id2 = b.id2
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30345407/viewspace-2150621/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
