SGA size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: SGA size

  1. #1
    Join Date
    Jul 2005
    Posts
    87

    SGA size

    I have 10203 database on windows and i started the instance with 100m sga
    will that be a problem?because for 10gR2 miniumn is 1gb of memory needs to be allocated ,so my question is will the instance get crashed because of inadequte memory allocated or any other problem.Please let me know.

    Thanks in advance

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    because for 10gR2 minimum is 1gb of memory needs to be allocated
    1G of memory is on server not for SGA. You need to explicitly allocate the memory to the SGA components or you can use SGA_TARGET parameter to automate the memory pools allocation except log buffer.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Nov 2008
    Posts
    11
    Quote Originally Posted by areeb
    I have 10203 database on windows and i started the instance with 100m sga
    will that be a problem?because for 10gR2 miniumn is 1gb of memory needs to be allocated ,so my question is will the instance get crashed because of inadequte memory allocated or any other problem.Please let me know.

    Thanks in advance
    by the way
    :if you OS version is 32bit, your memory must less than 1.7G. you can use
    SGA_MAX parameter for your increase of data.
    thanks!

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by areeb
    I have 10203 database on windows and i started the instance with 100m sga
    will that be a problem?because for 10gR2 miniumn is 1gb of memory needs to be allocated ,so my question is will the instance get crashed because of inadequte memory allocated or any other problem.Please let me know.

    Thanks in advance
    Sounds like you answered your own question.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jul 2005
    Posts
    87

    Smile

    Welcome back sir(Marist89)!!!

  6. #6
    Join Date
    Oct 2006
    Posts
    175
    Have at least a gig for Oracle though it might work with little lesser. But i see your system a lot & lot vulnerable with 100m.

    Thanks
    gtcol

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width