1、找到 sid ,serial#
select b.sid,b.SERIAL#
from SYS.V_$ACCESS a, SYS.V_$session b
where a.type = 'PROCEDURE'
and (a.OBJECT like upper('%存儲過程名%') or
a.OBJECT like lower('%存儲過程名%'))
and a.sid = b.sid
and b.status = 'ACTIVE';
2、kill 正在執(zhí)行的存儲過程
alter system kill session 'sid,SERIAL#';