OCP Blog
Super DBA
Oracle jobs, minimum interval,_job_queue_interval parameter
by Vazha Mantua Wednesday, September 5, 2012 3:21 PM

Good Day all,

Today we resolve problem which appear when you try run oracle job with interval less then 5 second, but unfortunately it run’s in 5 second.

Cause of this is default parameter of job_queue_interval, which is set 5 second. This parameter means wakeup interval in seconds for job queue coordinator , so we got 5 second gap with next job running.

On oracle documentation we read that job_queue_interval is obsolete in oracle 9i version , but there is hidden parameter with same name and it’s still valid, changed only technology , in oracle 8 it was snp background process, now it is job queue coordinator, which is responsible for job running.

So solution of decreasing job running interval is set _job_queue_interval with low value than 5 second.

you can also avoid change oracle hidden parameter, if you use dbms_scheduler.

 

 

Tags: , , , , , , , , , ,

Filter by APML

Calendar

<<  December 2017  >>
MoTuWeThFrSaSu
27282930123
45678910
11121314151617
18192021222324
25262728293031
1234567

View posts in large calendar

TextBox