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博客 ” ,链接:http://blog.itpub.net/16396910/viewspace-1034321/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16396910/viewspace-1034321/