今天在群里听到一个朋友说了一个DBA_BLOCKERS视图,于是查了一下官网的文档,了解了一下:
DBA_BLOCKERS displays a session if it is not waiting for a locked object but is holding a lock on an object for which another session is waiting.
--一个不需要等待锁的会话,但是它拥有了其他会话需要的锁
Select count(*) from v$session a ,dba_blockers b where a.sid=b.holding_session; --查找引起其他会话等待锁的会话
Alter system kill session 'sid,serial#';---用此语句kill掉引起其他会话等待锁的会话