存儲過程被鎖無法編譯的解決

　　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

　　殺掉這些進程就可以解鎖

From:http://tw.wingwit.com/Article/program/Oracle/201311/16585.html