0.查詢正在執行的存儲過程：

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

1. 在V$ACCESS視圖中找到要停止進程的SID:

舉例：存儲過程名：CRH_ENTRY

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

2. 在V$SESSION視圖中查找到查出SID和SERIAL#

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

3.殺掉查找出來的進程

alter system kill session 'SID,SERIAL#'

alter system kill session '1314,63759';