Oracle

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

日期:2015-06-28 00:00:00 来源: IT猫扑网

  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

  杀掉这些进程就可以解锁

相关文章

相关下载

网友评论

我要评论...
    没有更早的评论了
    取消