job_queue_processes ???

[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

[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.

[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

[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.

[julian]

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.

[ronnie]

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]

still waiting .......

[TerryD]

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.

[ronnie]

[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.