oracle强行停止存储过程

--查询正在执行的存储过程
  select * from v$db_object_cache where locks > 0 and pins > 0 and type='PROCEDURE';
 
 
  --查询活动的执行存储过程 session  id
   select b.sid,b.SERIAL#
  from SYS.V_$ACCESS a, SYS.V_$session b
 where a.type = 'PROCEDURE'
   and (a.OBJECT like upper('%EXPORT_DAILY%') or
       a.OBJECT like lower('%EXPORT_DAILY%'))
   and a.sid = b.sid
   and b.status = 'ACTIVE';
   
   --停止会话
   alter system kill session '133,13034';