3 Replies Latest reply: Apr 11, 2011 2:54 AM by Aman.... RSS

    increase sga size in oracle

    824208
      how to increase sga size in oracle
      please send example documentation
        • 1. Re: increase sga size in oracle
          mrak2
          hi ,

          for db using spfile :
          alter system set sga_target='200M' scope=both;-no db restart required,as long as the value did not exceed sga_max_size
          alter system set sga_max_size ='200M' scope=both; db restart required

          for db using pfile:
          edit your pfile, by changing the sga_target and sga_max_size.
          restart your db.
          it should change now.

          tq
          • 2. Re: increase sga size in oracle
            KG
            You have to mention the version of database

            if its 9i and have spfile

            use alter system set sga_max_size=value scope=spfile ;

            restart the database

            if it 10g and using ASMM then
            set sga_max_Size as above

            and use sga_target(dynamic) to control the memory allocation for sga components
            alter system set sga_target = value

            if 11g and using AMM
            difference in 11g and 10g if we define below parameters it considers pga memory allocation as well


            then use memory_max_target(static) and memory_target(dynamic)


            refer oracle database reference to understand them
            http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/initparams230.htm#CHDJFEBE
            • 3. Re: increase sga size in oracle
              Aman....
              Lingan patil(oracle dba) wrote:
              how to increase sga size in oracle
              please send example documentation
              I guess the more important question would be that whether you really need to do so i.e. that whether you really need to increase the SGA size from its current value. So besides your oracle version, if you can tell that why you want do it, it would fetch more appropriate replies.

              Aman....