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

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
杀掉这些进程就可以解锁