This discussion is archived
3 Replies Latest reply: Apr 11, 2011 12:54 AM by Aman.... RSS

increase sga size in oracle

824208 Newbie
Currently Being Moderated
how to increase sga size in oracle
please send example documentation
  • 1. Re: increase sga size in oracle
    mrak2 Explorer
    Currently Being Moderated
    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
    726175 Explorer
    Currently Being Moderated
    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.... Oracle ACE
    Currently Being Moderated
    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....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points