How to choose the number of workers for adop or adpatch

 How to choose the number of workers:

For less than 32 cores set:

• parallel_max_servers = 2 x number of CPU cores
• AD Parallel workers – start with 1.5 x number of CPU cores. Possibly increase to 2 x number of CPU cores
• job_queue_processes = 2 x number of CPU cores

For 32 cores and above, start with:

• parallel_max_servers = 1.5 x number of CPU cores
• AD Parallel workers = between 1.0 and and 1.5 x number of CPU cores
• job_queue_processes = 1.5 x number of CPU cores

EBS 12.2.9 RUP Patch 28840850 Hung with Error "aiosp2() Error: failure in usdspn() Contents of error buffer are: usdsop cannot create a new process" (Doc ID 2878394.1)