Question about initialization parameters on RAC
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?