Need Advice on job queue processes for upgrading to 12.2.10

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

Dear Erman,
We are upgrading our application from R12.1.3 to R12.2.10. Our database version is 19.17. We have 12 cores and a single server which hosts both application and database.
1) How much do you recommend for job_queue_processes parameter.
2) Do we need to set it in both CDB and PDB?

We need your advice. Please suggest.



Thanks & Regards,
Prabhu