Database Administration (MOSC)

MOSC Banner

Multiple PDBs

Dear Experts,

We use 12c & 19c Standard Architecture databases.

Going forward we are planning to convert all databasas to CDB

I've created 2 PDBs under one container DB (CDB1).

If i create multiple PDBs , do we need to take special care of adding additional background processes ( multiple dbwr, lgwr , etc ...) ?


[oracle@dgprim ~]$ ps -ef | grep ora_db*

oracle  4002 2055 0 03:17 pts/1  00:00:00 grep --color=auto ora_db*

oracle  30581   1 0 02:57 ?    00:00:00 ora_diag_cdb1

oracle  30587   1 0 02:57 ?    00:00:00 ora_dbrm_cdb1

oracle  30595   1 0 02:57 ?    00:00:01 ora_dia0_cdb1

oracle  30597   1 0 02:57 ?    00:00:01 ora_dbw0_cdb1

oracle  30634   1 0 02:57 ?    00:00:00 ora_d000_cdb1


>>


SQL> select name from v$database;

NAME

---------

CDB1

SQL> show pdbs;


 CON_ID CON_NAME   OPEN MODE RESTRICTED

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