Shulou(Shulou.com)06/01 Report--

JOB_QUEUE_PROCESSES specifies the maximum number of job slaves per instance that can be created for the execution of DBMS_JOB jobs and Oracle Scheduler (DBMS_SCHEDULER) jobs. DBMS_JOB and Oracle Scheduler share the same job coordinator and job slaves, and they are both controlled by the JOB_QUEUE_PROCESSES parameter.

If the value of JOB_QUEUE_PROCESSES is set to 0, then DBMS_JOB jobs and Oracle Scheduler jobs will not run on the instance.If JOB_QUEUE_PROCESSES is set to a value in the range of 1 to 1000, then DBMS_JOB jobs and Oracle Scheduler jobs will run. The actual number of job slaves created for Oracle Scheduler jobs is auto-tuned by the Scheduler depending on several factors, including available resources, Resource Manager settings, and currently running jobs. However, the combined total number of job slaves running DBMS_JOB jobs and Oracle Scheduler jobs on an instance can never exceed the value of JOB_QUEUE_PROCESSES for that instance. The number of job slaves running Oracle Scheduler jobs is additionally limited to the value of the MAX_JOB_SLAVE_PROCESSES Scheduler attribute. Advanced replication uses Oracle Scheduler for data refreshes. Oracle Streams Advanced Queuing uses Oracle Scheduler for message propagation. Materialized views use Oracle Scheduler for automatic refreshes. Setting JOB_QUEUE_PROCESS to 0 will disable these features as well as any other features that use Oracle Scheduler or DBMS_JOB.

For the Oracle job process, it includes the coordination process (the main process) and the slave process (child process).

B. Job_queue_processes ranges from 0 to 1000. The total number of job processes that can be created is determined by the job_queue_processes parameter.

C. When job_queue_processes is greater than 1 and job is executed in parallel, at least one is a coordination process. The total does not exceed the value of job_queue_processes.

The values of the d and job_queue_processes parameters are and DBMS_JOB is shared with DBMS_SCHEDULER.

E, job_queue_processes parameters, when the value is set to 0, the job created in any way will not run.

F, non-zero value of job_queue_processes, the number of jb child processes depends on available resources, resource configuration and the number of currently running job to adjust.

G, in addition, the Scheduler jobs mode is also limited to the setting of the scheduler property MAX_JOB_SLAVE_PROCESSES.

H. You can set max_job_slave_processes through DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE

This parameter can be implemented immediately by alter system.

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.