SQL> select r.sid,r.job,j.what,r.FAILURES from dba_jobs_running r, dba_jobs j
2 where r.job=j.JOB
3 ;
SID JOB WHAT FAILURES
---------- ---------- -------------------------------------------------------------------------------- ----------

After get the sid in the reslut

SELECT SID,SERIAL# FROM V$SESSION WHERE SID=&sid

ALTER SYSTEM KILL SESSION '&SID,&SERIAL# ';

[@more@]

ITPub博客

how to kill the runing job in ORACLE

最新文章