snapshot refresh, dbms_job interval vs job_queue_interval
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.
what version are you using, job_queue_interval has been obsolete since 9i
I also knew that. From 9i and later use _job_queue_interval.
But, my DBMS version is 8.1.7.
Click Here to Expand Forum to Full Width