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

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

select distinct s1.* from V$DB_OBJECT_CACHE   oc,

　　v$object_dependency od,

　　dba_kgllock         w,

　　v$session           s1

　　where oc.name = 'P_SPS_INTERFACE'

　　and od.TO_OWNER   = oc.OWNER

　　and od.TO_NAME    = oc.NAME

　　and od.TO_ADDRESS = w.kgllkhdl

　　and w.kgllkuse = s1.SADDR;

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

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

　　kill -8 spid

　　杀掉这些进程就可以解锁

　　select distinct s1.* from V$DB_OBJECT_CACHE   oc,

　　v$object_dependency od,

　　dba_kgllock         w,

　　v$session           s1

　　where oc.name = 'P_SPS_INTERFACE'

　　and od.TO_OWNER   = oc.OWNER

　　and od.TO_NAME    = oc.NAME

　　and od.TO_ADDRESS = w.kgllkhdl

　　and w.kgllkuse = s1.SADDR;

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

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

　　kill -8 spid

　　杀掉这些进程就可以解锁