Jump to Navigation

159 - DBA_JOBS, JOB_QUEUE_PROCESSES

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.

There are several data dictionary views that display information about the Oracle job queue.
These are called DBA_JOBS, USER_JOBS, and DBA_JOBS_RUNNING.

To change the parameter :

SQL> ALTER SYSTEM SET job_queue_processes = 100;

SQL> show parameter job_queue_processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- -----------------
job_queue_processes                  integer     100

 

 



Main menu 2

Story | by Dr. Radut