Database Administration (MOSC)

MOSC Banner

"processes" init parameter in multitenant environment

edited Jun 4, 2019 7:18AM in Database Administration (MOSC) 4 commentsAnswered ✓

Hi Guys,

"processes" init parameter can't be set in PDB level.

SQL> select  name, con_id, value, ISPDB_MODIFIABLE
from v$parameter where name ='processes';  2

NAME                     CON_ID VALUE                          ISPDB
-------------------- ---------- ------------------------------ -----
processes                     1 2000                           FALSE

I just want to confirm.. let's say I have set the init parameter to 2000. Does it means that the total (sum) of connections to the CDB and it's PDBs can't exceed 2000?

Is there any way I can limit it at PDB level as well?

thanks

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