Database Administration (MOSC)

MOSC Banner

Philosophical question about CDBs

edited Feb 24, 2026 3:50PM in Database Administration (MOSC) 4 commentsAnswered

If you have 3 databases, would you prefer to have (opt 1) 3 VM servers each with 1 CDB each containing 1 PDB. Or (opt 2) 1 VM server with 3 CDBs each with 1 PDB. Or (opt 3) 1 VM server with 1 CDB with 3 PDBs?

And, if you choose option 3, what do you name the CDB?

FYI, this is in reference to upgrading from on-prim non-CDB Oracle 19 databases to Oracle 26 CDB/PDB.

*** UPDATE ***

As a point of clarification, this question is intended to be more conceptional then real-life. As reference, I actually have 180 databases, 19 and 12, running on both Windows and Linux servers. I currently have 8 CDBs running 19. The production databases are all running on Option 1 with the non-production databases running on Option 3. But I'm not sure this is the best configuration. I'm concerned that Option 1 is a poor usage of resources, even though sometimes it will be necessary.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center