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.