Database - RAC/Scalability (MOSC)

MOSC Banner

Question about initialization parameters on RAC

edited Jul 14, 2017 1:48AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered ✓

I have a RAC installation where sga_max_size exists on both nodes

sga_max_size                         big integer 10G

Now I issue:

create pfile from spfile

I edit the pfile and I find:

*.sga_max_size=10G

DB1.sga_max_size=10G

DB2.sga_max_size=10G

Now I issue:

alter system reset sga_max_size scope=spfile sid='*';

create pfile from spfile

I edit the pfile and I find:

DB1.sga_max_size=10G

DB2.sga_max_size=10G

What will happen if I restart the database now? Is the sga_max_size going to be reset or not?

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