-
snapshot refresh, dbms_job interval vs job_queue_interval
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|