12.2 NEW FEATURE JOB_QUEUE_PROCESSES=4000 CAN ONLY HANDLE A MAXIMUM OF 1024 JOBS
Last updated on OCTOBER 17, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms