4 Replies Latest reply on Jan 5, 2013 1:27 PM by user12159566

    SGA Parameter setting problem


      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?