Oracle中的包、存储过程、函数被锁定解决方案

1、查出是哪些进程锁住了指定的对象
Select b.SID,b.SERIAL# From dba_ddl_locks a, v$session b Where a.session_id = b.SID And a.name = ' RE_ANALYSISMODEIMAGE_PKG ';

2、结束进程数据
alter system kill session 'sid,serial#'
 
3、如果不能正常结束
Select spid, osuser, s.program From v$session s, v$process p Where s.paddr = p.addr And s.sid in (Select b.SID  From dba_ddl_locks a, v$session b Where a.session_id = b.SID And a.name = ' RE_ANALYSISMODEIMAGE_PKG ')
 
4、结束进程 不同操作系统会有所不能

转载于:https://www.cnblogs.com/Nadim/archive/2012/11/10/2764383.html