强制停止存储过程的方式

停止定时器跑出的存储过程的方法
select b.sid,
b.SERIAL#,
a.OBJECT,
‘alter system kill session ’ || ‘’’’ || b.sid || ‘,’ || b.SERIAL# ||
‘’’;’ kill_command
from SYS.V_ACCESS a, SYS.V_session b
where a.type = ‘PROCEDURE’
and (a.OBJECT like upper(’%test_pcb%’) or
a.OBJECT like lower(’%test_pcb%’))
and a.sid = b.sid
and b.status = ‘ACTIVE’;

select pro.spid
from v$session ses, v$process pro
where ses.sid = 7
and ses.paddr = pro.addr;

直接在数据库服务器上kill -9 spid 即可

查询正在运行的job的spid：
select a.spid from v$process a ,v$session b where a.addr=b.paddr and b.sid in (select sid from dba_jobs_running);

select SID,JOB from dba_jobs_running;

select SID,JOB from users_jobs_running;

select a.spid from v$process a ,v$session b where a.addr=b.paddr and b.sid =SID;