-
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.
-
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
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
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.
-
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
-
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.
-
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
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.
-
[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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|