Why is the job_queue_processes parameter not working in multitenant?
Hello, I'm using Oracle Database 19c Enterprise Edition Release - Version 19.25.
I created a multitenant environment with multiple PDBs, but I noticed that I never have more than two jobs running, even with job_queue_processes set to 20.
Below is a test case I ran in cdb$root, where I created 10 jobs with a 5-second sleep time, and then monitored them in cdb_scheduler_jobs, showing that there were never more than two running.
16:54:11 SYS@cdb19sup1 [ 1- 766]>show con_name
CON_NAME
CDB$ROOT
16:54:14 SYS@cdb19sup1 [ 1- 766]>
16:54:15 SYS@cdb19sup1 [ 1- 766]>
16:54:15 SYS@cdb19sup1 [ 1- 766]>show parameter job_queue_processes