Shulou(Shulou.com)05/31 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.