Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center