Re: Need Advice on job queue processes for upgrading to 12.2.10

Posted by ErmanArslansOracleBlog on Oct 12, 2023; 8:11am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Need-Advice-on-job-queue-processes-for-upgrading-to-12-2-10-tp12101p12108.html

Minimum value of it should be 2..
But that depends.. That depends on your AQ event messages-related and workflow-related activity.
Also it depends on your custom things that use dbms job.
However; as your core count# is 12.. I don't recommend setting job_queue_processes to a higher value than 12. (although I don't know your workload .. just in case..)