I need to increase SGA_MAX_SIZE & SGA_TARGET from 12gb to 18gb in Oracle 10gR2 2 node RAC database on windows 2003
Instance 1 is not getting change after changed using 'alter system set SGA_MAX_SIZE=18G scope=spfile; command. Instance 2 only increased SGA size.
both the instance reading same spfile in ASM. is there any specification for sga limit on windows 2003?