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

<<  October 2017  >>
MoTuWeThFrSaSu
2526272829301
2345678
9101112131415
16171819202122
23242526272829
303112345

View posts in large calendar

TextBox