how to kill the runing job in 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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORCLE 如何停止一個JOB【HOW TO STOP A JOB IN THE ORACLE?】薦Oracle
- How To Kill Good IdeasGoIdea
- Kill執行中的JOB的問題
- How to get Timer Job History
- Kill Oracle Local=NOOracle
- kill oracle jobsOracle
- Oracle kill sessionOracleSession
- oracle jobOracle
- 【kill session】Oracle 徹底 kill session(轉載)SessionOracle
- Oracle kill session scriptOracleSession
- oracle_kill_sessionOracleSession
- Oracle中Kill sessionOracleSession
- Oracle批量kill sessionOracleSession
- How To Stop A Running Datapump Job Started In Background [ID 958532.1]
- oracle建立job並執行jobOracle
- oracle job用法Oracle
- oracle job管理Oracle
- ORACLE查詢JOB資訊及JOB建立Oracle
- Oracle 徹底 kill sessionOracleSession
- Windows下kill oracle程式WindowsOracle
- Oracle中Kill session [轉]OracleSession
- How Oracle Works!Oracle
- How to Study OracleOracle
- 【JOB】Oracle JOB全面學習(DBMS_JOB和DBMS_SCHEDULER)Oracle
- oracle job管理(zt)Oracle
- oracle 定義jobOracle
- Oracle JOB的使用Oracle
- Oracle job備忘Oracle
- oracle job的用法Oracle
- oracle job 介紹Oracle
- oracle job 用法2Oracle
- Oracle中的jobOracle
- Oracle job 管理(轉)Oracle
- Oracle中如何停用JOB及如何使用JOBOracle
- Oracle中Kill session的研究 for oracle -- 轉OracleSession
- 【會話】Oracle kill session系列會話OracleSession
- Oracle中Kill session的研究OracleSession
- How to enable trace in OracleOracle