oracle 终止存储过程

1.查找正在运行的存储过程

select *
from v$db_object_cache
where locks > 0 and pins > 0 and type='PROCEDURE';

2.查找对应的sid

SELECT t.* FROM V$ACCESS t WHERE t.object='PROC_FIX_SHP_PROJECT_ONOFF'; 

3.根据sid查找对应的serial

SELECT SID,SERIAL# FROM V$SESSION WHERE SID='1440'; 

4.删除对应进程

alter system kill session '1440,59643';