oracle怎么强制停止服务,强制停止存储过程的方式

停止定时器跑出的存储过程的方法

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 vsessionses,vsession ses, vsessionses,vprocess pro

where ses.sid = 7

and ses.paddr = pro.addr;

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

查询正在运行的job的spid：

select a.spid from vprocessa,vprocess a ,vprocessa,vsession 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 vprocessa,vprocess a ,vprocessa,vsession b where a.addr=b.paddr and b.sid =SID;