1.查找出被锁定的会话的sid,serial#
select sid,serial# from v$session t where t.SID IN (select session_id from v$locked_object);
2.结束掉进程(有几行执行几次)
alter system kill session '25,3343';kill system
1.查找出被锁定的会话的sid,serial#
select sid,serial# from v$session t where t.SID IN (select session_id from v$locked_object);
2.结束掉进程(有几行执行几次)
alter system kill session '25,3343';kill system