job_queue_processes ???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: job_queue_processes ???

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Hi,

    whats the job_queue_processes parameter for.

    I have an idea that it has to be greater than 0 for jobs to be executed.

    What exactly does the value for this parameter signify and how does it affect the database.

    Thanks
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    May 2002
    Posts
    37
    This parameter specifies number of SNP background processes, used for snapshot refresh and to process requests created by DBMS_JOB.
    It also affects memory allocation.

    Regards.

  3. #3
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Does this mean that if the value of job_queue_processes is set to 5 I can only have 5 jobs scheduled for the same time.

    Also I noticed that the value specified for this parameter creates those many number of sessions with no specified username and they are always active.

    Is it a good idea to set this to the maximum values (10)

    Please suggest

    Thanks
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    I believe before 9i the max number was 36, and with 9i, it is 1000. Default is 0. There will be automatic processes running at times - things you did nothing to create or submit.

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by dave777
    This parameter specifies number of SNP background processes, used for snapshot refresh and to process requests created by DBMS_JOB.
    It also affects memory allocation.

    Regards.
    In 9i, the name is not SNPn but Jnnn.


    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  6. #6
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Originally posted by ronnie
    Does this mean that if the value of job_queue_processes is set to 5 I can only have 5 jobs scheduled for the same time.

    Also I noticed that the value specified for this parameter creates those many number of sessions with no specified username and they are always active.

    Is it a good idea to set this to the maximum values (10)

    Please suggest

    Thanks

    Thanks for the correction on maximun Job Processes.

    But I am still waiting for my other answers.

    Thanks
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  7. #7
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    still waiting .......
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  8. #8
    Join Date
    Sep 2000
    Posts
    128
    Does this mean that if the value of job_queue_processes is set to 5 I can only have 5 jobs scheduled for the same time.
    This would be mean that you will only have 5 processes serving the job queue at any one time.

    On my system, jobs are submitted by users for immediate execution (well, dictated by job_queue_interval) - to limit the number of processes that can run simultaneously I have set this to 3. Jobs that don't get there first have to wait for the others to finish.
    I guess you can set it to what you think you require, but as you say, each will create a session and a process, so make sure your system can handle whatever you set it to.

  9. #9
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    [QUOTE]Originally posted by TerryD

    I guess you can set it to what you think you require, but as you say, each will create a session and a process, so make sure your system can handle whatever you set it to. [/B]
    What exactly do you mean that the system should be able to handle it.
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

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