Analysis of job_queue_processes parameters of oracle11g
This article mainly explains "oracle 11g job_queue_processes parameter problem analysis", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let Xiaobian take you to learn "oracle11g job_queue_processes parameter problem analysis"!
A job was recently created in an oracle 11g database, and the job will not run at the set time. But it's okay to run it manually. Later, I found the reason online, because of the parameter setting problem of job_queue_processes:
1. job_queue_processes values range from 0 to 1000
2. When this value is set to 0, jobs created in any way will not run.
3. When this value is set greater than 1, and jobs are executed in parallel, at least one is a coordinator process. The total does not exceed the value of job_queue_processes.
Execute the show parameter job_queue_process; command on the command line to view the job_queue_processes parameter:
SQL> show parameter job_queue_process;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 0
A parameter value of 0 means that the job task will not run.
To run the job task, you need to set the job_queue_processes parameter value greater than 0, set the command: ALTER SYSTEM SET job_queue_processes = 10; this 10 can be changed to a number between 1 and 1000 as needed.
SQL> ALTER SYSTEM SET job_queue_processes = 10;
System altered
--View job_queue_process parameter value again
SQL> show parameter job_queue_process;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 10
At this point, I believe that everyone has a deeper understanding of "oracle 11g job_queue_processes parameter problem analysis", may wish to actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!
