删除正在运行的procedure

删除正在运行的procedure

1.select * from dba_jobs_running; 如果存储过程是以job方式定期运行的话

2.select name from v$db_object_cache where type='PROCEDURE'; 如果非job运行，则查询v$db_object_cache

，缓存中查询

3.SELECT * FROM V$ACCESS WHERE OBJECT ='SUM_REPORT'; 查看要删除的存储过程sum_report,类型是否为存储

过程

4.SELECT B.SID,B.SERIAL#,A.OWNER,A.OBJECT,A.TYPE FROM V$ACCESS A , V$SESSION B WHERE A.SID=B.SID AND

A.OBJECT ='SUM_REPORT';

5.alter system kill session 'sid,serial#' immediate; 杀死会话

ERROR at line 1:
ORA-00031: session marked for kill

6.若上述错误，则处理如下：

SQL> select spid,osuser,s.program from v$session s,v$process p where s.paddr=p.addr and s.sid=136; 136

为上述sid

7.命令行下：kill -9 spid