Need Advice on job queue processes for upgrading to 12.2.10

[prabhunoule]

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

[ErmanArslansOracleBlog]

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..)

[prabhunoule]

Thank you erman,

Can you please confirm for second question?

2) Do we need to set it in both CDB and PDB?





Regards,
Prabhu

[ErmanArslansOracleBlog]

From 12.2 onwards JOB_QUEUE_PROCESSES is PDB modifiable..

But! setting it on CDB level is enough.. This is EBS and your CDB is dedicated to EBS PDB.. So setting it centrally on CDB level is enough.

Still it is better to test it..
Create a dbms_job on a PDB, set job_queue_processes to a non-zero value of CDB.. Don't set it to anything on PDB.. Execute that job you just created and see whether it is executed or not.. If your job is not executed, then set job_queue_processes both on CDB and PDB level.. But if your is executed properly, you don't need to set it on PDB level..