//获取正在运行的job
select * from dba_jobs_running;
//获取正在运行job(24)的详细信息
select b.SID,b.SERIAL#,c.SPID
from dba_jobs_running a,v$session b,v$process c
where a.sid = b.sid and b.PADDR = c.ADDR and a.job=24
//杀死job
ALTER SYSTEM KILL SESSION '75,46547';
select * from dba_jobs_running;
//获取正在运行job(24)的详细信息
select b.SID,b.SERIAL#,c.SPID
from dba_jobs_running a,v$session b,v$process c
where a.sid = b.sid and b.PADDR = c.ADDR and a.job=24
//杀死job
ALTER SYSTEM KILL SESSION '75,46547';