存储过程被锁无法编译的解决

select distinct s* from V$DB_OBJECT_CACHE oc

v$object_dependency od

dba_kgllock w

v$session s

where ocname = P_SPS_INTERFACE

and odTO_OWNER = ocOWNER

and odTO_NAME = ocNAME

and odTO_ADDRESS = wkgllkhdl

and wkgllkuse = sSADDR;

得到锁定存储过程的进程PADDR

select spid from v$process p where paddr=(PADDR值)

kill spid

杀掉这些进程就可以解锁

上一篇：删除重做日志文件组的四大限制条件

下一篇：autoconf手册（四）