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
Printable View
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
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.
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
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.
In 9i, the name is not SNPn but Jnnn.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.
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
still waiting .......
This would be mean that you will only have 5 processes serving the job queue at any one time.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.
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.
[QUOTE]Originally posted by TerryD
What exactly do you mean that the system should be able to handle it.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]