Database Administration (MOSC)

MOSC Banner

Can I oversize TARGET_PDB parameter in RDBMS 19c

edited Apr 10, 2020 5:02AM in Database Administration (MOSC) 5 commentsAnswered

Hello,

We operate a large fleet of  databases, most 12.2.0.1, and we are migrating to 19c. The 2644243.1 note point performances issues with PDB, the workarond is to set the TARGET_PDB parameter "as close as possible to the number of planned PDBs".

We have still databases withe no PDB (less and less), a majority between 5 and 10 PDB, and a few with 20+ PDB.

I wonder if it is harmful to have a significantly increased parameter, or if I can set the parameter to the max number of PDB we have on a CDB.

Does anyone have any feedback on this point?

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