熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

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

2013-11-13 12:47:17  來源: Oracle 

  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
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.