12.2 NEW FEATURE JOB_QUEUE_PROCESSES=4000 CAN ONLY HANDLE A MAXIMUM OF 1024 JOBS
(Doc ID 2315892.1)
Last updated on NOVEMBER 27, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Setting job_queue_processes=4000 should allow a maximum of 4000 jobs to be executed simultaneously as long as OS resources allow this to happen. However, on a system with sufficient resources the maximum number of simultaneous jobs that we can run is 1024.
Testcase:
Despite the fact that sufficient resources are available the number of maximum simultaneous jobs will not overcome a limitation of 1024.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |