原因: 存儲過程執行過程中,關閉或者中斷存儲過程,重新編譯是等待時間很長,無法删除
解決:
先查出被鎖定存儲過程的spid
select spid
from v$db_object_cache oc,
v$object_dependency od,
dba_kgllock w,
v$session s,
v$process p
where od.to_owner = oc.owner
and od.to_name = oc.name
and od.to_address = w.kgllkhdl
and w.kgllkuse = s.saddr
and p.addr = s.paddr
and oc.name = ‘sp_ps_datawwtpflowsum_u‘//存儲過程名稱
登陸被鎖定存儲過程所屬oracle的安裝伺服器, 開始->運作->cmd ,輸入格式 orakill
sid執行個體 spid如:c:\>orakill orcl 540