Database Administration (MOSC)

MOSC Banner

Init.ora parameters in CDB / PDB

in Database Administration (MOSC) 4 commentsAnswered

Hello

We are converting our non PDBs 19c database to a multi tenant architecture

We have a couple of questions on the init.ora settings related to that

Here are our current settings (non multi tenant) for some of the parameters

processes = 500

sga_target = 20G

sga_max_size = 30G

open_cursors = 1000

pga_aggregate_target = 10G

Assuming that we would have 2 PDBs in each container should we be making the changes

at ROOT / CDB$ level or at each PDB level for these init.ora parameters

And should the value in the CDB / ROOT container be the total of both values in each PDB?

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