HOW TO Kill The Running Job in Oracle
来源:互联网 发布:蛟龙号的数据 编辑:程序博客网 时间:2024/06/04 06:38
Sometime we have frustrated to kill the running Job in Oracle even though we already kill him from OS but the job still running. Using this step could kill your stress, I mean your running Job. Good Luck –
1. Check the running Job (From here you will get the SID that running the Job)
SQL> SELECT * FROM DBA_JOBS_RUNNING;
2. Make Job become Broken/offline
BEGIN SYS.DBMS_IJOB.BROKEN(job#,TRUE); END;
SQL> BEGIN SYS.DBMS_IJOB.BROKEN('136451',TRUE); END;
3. Kill the Oracle’s Session
SQL> ALTER SYSTEM KILL SESSION 'sid,serial#';
4. Kill the O/S Process ID (PID)
SELECT p.spid FROM v$session s, v$process p
WHERE s.paddr = p.addr
AND s.sid = :sid;
For Windows, at the DOS Prompt: orakill sid spid
For UNIX at the command line> kill '9 spid
Ussually Oracle Job running with Process Name : ora_j00%
5. Check if the Job is Still Running
SQL> SELECT * FROM DBA_JOBS_RUNNING;
6. Determine the Current Number of Job Queue Processes
SQL> col value for a10
SQL> select name,value from v$parameter where name = 'job_queue_processes';
7. Alter the Job Queue to Zero
SQL> ALTER SYSTEM SET job_queue_processes = 0;
This will bring down the entire job queue processes.
8. Validate that No Processes are Using the Job Queue
SQL> SELECT * FROM DBA_JOBS_RUNNING;
9. Mark the DBMS_JOB as Not Broken
BEGIN SYS.DBMS_IJOB.BROKEN(job#,FALSE); END;
10. Alter the Job Queue to Original Value
SQL> ALTER SYSTEM SET job_queue_processes = original_value;
- HOW TO Kill The Running Job in Oracle
- how-to-kill-the-running-job
- 【Vegas原创】How to rebuild the inflexible Oracle Job?
- 【Vegas原创】How to rebuild the inflexible Oracle Job?
- how to let the process kill itself?
- How-to: Enabled hive job running support on hive
- How to fix “The system is running in low-graphics mode” Ubuntu 17.04 or 16.04
- How to handle the pressure job
- how to debug the background job
- How to Find the Best Person for the Job
- How to tell if you’re running the 32 bit or 64 bit kernel in Mac OS X Snow Leopard
- How to get Ogre3D running on iOS in 15 minutes!
- How to use ArcGIS samples for help running the sample
- How to do the job effectively and excellently
- how to check oracle current running sql status?
- how to check oracle current running sql status?
- Oracle - How to enable/disable a scheduled job?
- How to remove ^M in the file
- Android Wifi 手机摄像头 SECuRET LiveStream
- 无niao~~~~~~~~
- 又是郁闷的一晚
- StormLibSharp
- memcpy 内联汇编简写版
- HOW TO Kill The Running Job in Oracle
- 2011/2/15 周二 P4+sln带来的麻烦
- access主数据字段类型
- Ogitor探索之代码分析(2)---void MainWindow::newScene()
- org.eclipse.ui.startup扩展点介绍
- moodle 2 new features
- 关于复用套接字
- 四问云GIS
- 在同一个线程中,只有存在一个活动的Display