My Oracle Support Banner

JOB_QUEUE_PROCESSES Parameter, its Significance and Recommended value (Doc ID 2118028.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.

Goal

This document aims to explain the JOB_QUEUE_PROCESSES initialization parameter and its significance in the database.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 What are JOB_QUEUE_PROCESSES ?
 Allowed Ranges and Default values
 JOB_QUEUE_PROCESSES in multitenant database
 How to set JOB_QUEUE_PROCESSES ?
 Significance of setting JOB_QUEUE_PROCESSES =0
 How to determine the correct setting for JOB_QUEUE_PROCESSES?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.