查询V$LOCKED_OBJECT得到SID和OBJECTID,然后拿这个SID到V$SESSION中查询知道是谁锁的 --查看锁 select t2.username,t2.sid,t2.serial#,t2.logon_time from v$locked_object t1, v$session t2 where t1.session_id=t2.sid order by t2.logon_time;--alter system kill session 'sid,serial#'; --把锁给KILL掉 alter system kill session '146,21177';对象
--查看锁
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$locked_object t1, v$session t2
where t1.session_id=t2.sid order by t2.logon_time;--alter system kill session 'sid,serial#';
--把锁给KILL掉
alter system kill session '146,21177';对象