Oracle 表和存储过程解锁

表解锁：

查找锁住的表的 sid,serial#

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;

根据找到的sid,serial#解锁：

alter system kill session 'sid,serial#' 

存储过程解锁：

select * from dba_ddl_locks where name =upper('存储过程名称')
select t.sid,t.serial# from v$session t 
where t.sid=SESSION_ID;

根据找到的sid,serial#解锁：
alter system kill session 'sid,serial#';