--查询存储过程
SELECT * FROM V$DB_OBJECT_CACHE WHERE name='存储过程名字' AND LOCKS!='0';
--查询SID
select /*+ rule*/ SID from V$ACCESS WHERE object='存储过程名字';
--查询SERIAL
SELECT SID,SERIAL#,PADDR FROM V$SESSION WHERE SID='1893';
--杀掉进程
alter system kill session '1893,53202' immediate;