1、找出正在执行的job编号 和会话编号
SELECT
*
FROM
dba_jobs_running;
2、停止job的运行
SELECT
SID
,serial#
FROM
v$session
WHERE
SID
=
'$SID'
;
EXEC
dbms_job.broken(&JOB,
TRUE
);--一定要先broken
ALTER
SYSTEM
KILL
SESSION
'&sid,&session'
;--杀掉job进程
----------------也可用如下方法--------------------------
SELECT
P.SPID,
A.SERIAL#,
C.OBJECT_NAME,
B.SESSION_ID,
B.ORACLE_USERNAME,
B.OS_USER_NAME,
A.SID
FROM
V$PROCESS P, V$SESSION A, V$LOCKED_OBJECT B, ALL_OBJECTS C
WHERE
P.ADDR = A.PADDR
AND
A.PROCESS = B.PROCESS
AND
C.OBJECT_ID = B.OBJECT_ID
ORDER
BY
6
-----------------------------------------------