Oracle job 情况的查看处理
Jun 07, 2016 pm 05:04 PM注意:当一个job的执行周期是3分钟执行一次,而你设参数job_queue_interval=600(10分钟),而你只有一个SNP进程的话,你的这个JOB
exec dbms_job.broken(23,false);
commit;
select t.*, t.rowid from dba_jobs t;
select t.*, t.rowid from sys.user_jobs t;
select job, last_date, next_date, broken, interval, failures
from user_jobs;
当一个job运行时返回一个error是,Oracle会再次设法执行它,,第一次尝试是在一分钟后,第二次是在2分钟后,第三次是4分钟后,以此类推。每次尝试的周期加倍,直到下一次的运行时刻来到,又再次尝试,当尝试执行失败16次时,oracle自动标示此job为broken,不再执行此任务。
注意:当一个job的执行周期是3分钟执行一次,而你设参数job_queue_interval=600(10分钟),而你只有一个SNP进程的话,你的这个JOB将10分钟执行一次,失败16次后将标示为broken。因为你的job的执行周期被SNP进程的唤醒周期限制。那么每次尝试的时间间隔成倍的情况不会出现。
select job, last_date, next_date, broken, interval, failures
from user_jobs;
看看结果是什么?
注意,如果failures中job的失败次数,如果超过15次job就停止了.
broken显示Y,则job不可用了
是16次运行不成功,JOB就会自动停掉。

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Use ddrescue to recover data on Linux

Open source! Beyond ZoeDepth! DepthFM: Fast and accurate monocular depth estimation!

How to use Excel filter function with multiple conditions

The vitality of super intelligence awakens! But with the arrival of self-updating AI, mothers no longer have to worry about data bottlenecks

Google is ecstatic: JAX performance surpasses Pytorch and TensorFlow! It may become the fastest choice for GPU inference training

Slow Cellular Data Internet Speeds on iPhone: Fixes

The U.S. Air Force showcases its first AI fighter jet with high profile! The minister personally conducted the test drive without interfering during the whole process, and 100,000 lines of code were tested for 21 times.

The first robot to autonomously complete human tasks appears, with five fingers that are flexible and fast, and large models support virtual space training
