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