snapshot refresh, dbms_job interval vs job_queue_interval

[danghongsinh]

Hi all,

At present, my system is setting up a snapshot refresh and dbms_job with interval 10 second and set job_queue_interval=60 in init.ora. It seems refresh time about 60 seconds. But I want refresh time is 10 second. How can I setting these parameters? What happen if I remove job_queue_interval parameter in init.ora?

Please help me if you know.

Thanks,
SinhDH

[davey23uk]

what version are you using, job_queue_interval has been obsolete since 9i

[danghongsinh]

I also knew that. From 9i and later use _job_queue_interval.
But, my DBMS version is 8.1.7.