Java,J2EE,Weblogic,Oracle

 
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#';