permisible sga size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: permisible sga size

Hybrid View

  1. #1
    Join Date
    May 2002
    Posts
    193
    Dear Sir,

    I have a total sga size of around 36% of my ram (on advanced server 2000). What is the maximum allowable size of the total ram (% share of total memory) can the sga have (as a thumb rule). I need to know this as I will have to increase the buffers for a greater hit ratio.

    Regards,

    K.Diwakar

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Hi,

    I read somewhere that Oracle recommends a maximum of 70% of the total availiable RAM but it really depends on what else you have running on the box, and how many connection you are likely to have. You need to ensure you don't increase the size beyond the amount of physical memory as paging will seriously effect performance.

    Regards

    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    May 2002
    Posts
    193
    Dear Sir

    I think in unix one can have an SGA size of aroung 55% to 60% and not more that that for reasons as you say, and in a windows environment it is lesser than that. Ofcourse one should take other parameters before increasing the buffers, I precisely need to know the maximum percentage as a rule of thumb.

    K.Diwakar

    [Edited by diwakar on 06-12-2002 at 05:50 AM]

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