My Oracle Support Banner

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

Last updated on JULY 02, 2024

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6 to 12.2.6 [Release 12.2]
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
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.