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

Thread: JOB_QUEUE_INTERVAL

  1. #1
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    boss

    oracle 8.1.7 windows 2000 advance server

    job_queue_interval = 10
    job_queue_process=4

    are the numbers ok, or it needs to be less or more.
    i am not able to understand the true meaning and numbers behind these 2 parameters.

    pravin
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Originally posted by pravin
    boss

    oracle 8.1.7 windows 2000 advance server

    job_queue_interval = 10
    job_queue_process=4

    are the numbers ok, or it needs to be less or more.
    i am not able to understand the true meaning and numbers behind these 2 parameters.

    pravin
    job_queue_interval = 10 --> for every 10 sec oracle instance checks to there are any jobs to run
    job_queue_process=4 ---> Four back ground jobs proceeses will be ready to serve the jobs that are scheduled to run.

    You don't need 4 processes if you don't have that many jobs to run...
    Reddy,Sam

  3. #3
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    sam thank u !!!
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

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