12.2 NEW FEATURE JOB_QUEUE_PROCESSES=4000 CAN ONLY HANDLE A MAXIMUM OF 1024 JOBS
(Doc ID 2315892.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
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.
Despite the fact that sufficient resources are available the number of maximum simultaneous jobs will not overcome a limitation of 1024.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!