--查询锁表
select a.SID,a.SERIAL# from v$session a , v$locked_object b where a.SID = b.SESSION_ID;
--杀锁
alter system kill session 'sid,serial#'
select a.SID,a.SERIAL# from v$session a , v$locked_object b where a.SID = b.SESSION_ID;
--杀锁
alter system kill session 'sid,serial#'