job_queue_processes ???

Printable View

05-13-2002, 04:01 PM
ronnie

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
05-13-2002, 04:51 PM
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.
05-13-2002, 05:01 PM
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
05-13-2002, 06:37 PM
stecal

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.
05-14-2002, 03:18 AM
julian

Quote:

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.
05-14-2002, 11:28 AM
ronnie

Quote:

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
05-14-2002, 03:07 PM
ronnie

still waiting .......
05-14-2002, 08:33 PM
TerryD

Quote:

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.
05-15-2002, 09:36 AM
ronnie

[QUOTE]Originally posted by TerryD

Quote:

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.