　　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

　　杀掉这些进程就可以解锁

[@more@]

ITPub博客

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