DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: snapshot refresh, dbms_job interval vs job_queue_interval

  1. #1
    Join Date
    Mar 2007
    Posts
    21

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what version are you using, job_queue_interval has been obsolete since 9i

  3. #3
    Join Date
    Mar 2007
    Posts
    21
    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
  •  


Click Here to Expand Forum to Full Width