4 Replies Latest reply: Jan 5, 2013 7:22 AM by JohnWatson RSS

    SGA Parameter setting problem

    user12159566
      Hi,

      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?


      Thanks.