select
(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
查询哪些session阻塞了哪些其他进程.
alter system kill session 'sid,serial#';
杀掉session 51Testing软件测试网&c
如何查看系统存在的死锁会话
最新推荐文章于 2021-04-04 11:10:43 发布