发布时间:2013-09-24 10:55:54
1. Check the running Job (From here you will get the SID thatrunning the Job)SQL> SELECT * FROM DBA_JOBS_RUNNING;2. Make Job become Broken/offlineBEGIN SYS.DBMS_IJOB.BROKEN(job#,TRUE); END;SQL> BEGIN SYS.DBMS_IJOB.BROKEN('136451',TRUE); END;3. Kill the Oracle’s SessionSQ.........【阅读全文】