how to kill the runing job in ORACLE

oo0yuki0oo發表於2011-07-19

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部落格 ” ,連結:http://blog.itpub.net/8337095/viewspace-1052703/,如需轉載,請註明出處,否則將追究法律責任。

相關文章