Database Administration (MOSC)

MOSC Banner

What does job_queue_processes in a pluggable database signify?

edited Jul 21, 2016 5:03AM in Database Administration (MOSC) 5 commentsAnswered

 

In “JOB_QUEUE_PROCESSES Parameter, its Significance and Recommended value (Doc ID 2118028.1)” it states:

<< In 12.1.0.1, job_queue_process was a Container Database (CDB) modifiable parameter (ie. at a global level). However, in 12.1.0.2, the job_queue_process parameter is not CDB modifiable; instead it's PDB modifiable which means each PDB can have its own job_queue_process value.>>

 

How should this be understood, in regards to the value you set for a given PDB?

 

For example, in our 12.1.0.2 CDB we have two PDBs, job_queue_processes at CDB level is set to 24, and in each PDB the parameter is set to 12. E.g:

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