DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: job_queue_processes parameter

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Question

    We are on 8.1.5

    The doc. says that this parameter is for:
    JOB_QUEUE_PROCESSES specifies the number of SNPn background processes per
    instance...

    So, if we have 8 jobs (that I can see in dba_jobs) and our job_queue_processes = 3; what does this mean ?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    JOB_QUEUE_PROCESSES is OS process
    Jobs is scheduled jobs

  3. #3
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    so what is the relationship between the two, if any; is there a limit (parameter) to the number of oracle jobs that I can schedule?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    relation is if you dont have snpX processes you cant run scheduled jobs because those processes are the one who checks for jobs

    Job queue processes process requests created by DBMS_JOB, and those requests are the scheduled JOBs

  5. #5
    Join Date
    Jun 2001
    Posts
    243
    so is it good to have many job_queue_processes set or not?
    one of my database server set job_queue_processes=0 and the other server is set to 14...

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I set it to 4 because I have like 12 jobs only and they run in different hours

  7. #7
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Wink

    So what is a good job_queue_process number for lets say 15 jobs ? Is there a rule-of-thumb ?

    Lets say job_queue_process =1, and there are 50 jobs, will some of them be delayed since there is only one SNP background process...have you seen any doc. that addresses this topic.

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Nop, I just use common sense, I schedule the jobs in different hours at most I have 2 jobs running concurrently so 4 is enough for my 12 jobs

  9. #9
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Wink

    Thank you, I appreciate the quick responses.

  10. #10
    Join Date
    Jun 2001
    Posts
    243
    I really have to understand better on init.ora files...any good sources or book that I can study..I have the Oracle Database Administration book from O'Reilly, but the explanation is too vague....any other good init.ora parameter file books or info

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