how to kill the runing job in ORACLE

oo0yuki0oo發表於2011-07-19
Oracle

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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章