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

Thread: JOB_QUEUE_INTERVAL

  1. 08-08-2002, 02:23 PM #1
    pravin
    pravin is offline Senior Member
    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 -

    [email protected]
    Reply With Quote Reply With Quote
  2. 08-08-2002, 02:46 PM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  3. 08-08-2002, 03:29 PM #3
    pravin
    pravin is offline Senior Member
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    sam thank u !!!
    Eat , Drink & Enjoy life -

    [email protected]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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