SGA size for 100gb database?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SGA size for 100gb database?

Hybrid View

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    SGA size for 100gb database?

    What SGA size can be set for my new OLTP database?
    Database size going to be 100gb.RAM-4GB ,4-processor ,oracle- 8.1.7 on sun solaris- 8 with SUN Hardware
    J Gangadhar

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    if i remmeber rightly, the max SGA size on 8.1.7 is 1.75 Gb unless you relink your libraries with some flag.

    So use 1.75 Gb :-)

    On our we use about 100Mb for shared pool unless you have heaps and heaps of pl/sql code.

    Do you use java, if so set your java pool

    use majoirty on block buffers

    This assumes one instance and having an app that doesnt require gobs of RAM

  3. #3
    Join Date
    Dec 2003
    Posts
    11
    Hi,

    "bigger is better"
    But it is difficult to answer generally.

    You can find the exact hint for resizing of memory on www.metalink.oracle.com.

    Searching phrase :1028623.6

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: SGA size for 100gb database?

    Originally posted by ganga
    What SGA size can be set for my new OLTP database?
    Database size going to be 100gb.RAM-4GB ,4-processor ,oracle- 8.1.7 on sun solaris- 8 with SUN Hardware
    You can not give a direct answer to this question. How much PL/SQL code will the application use? The shared pool size depends on that. If this is the only DB running on that Solaris box you may start with using 60-70% of the RAM for thr SGA. Use large pool if SQL statements use parallel slaves or you backup with RMAN to tape.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  5. #5

    Re: SGA size for 100gb database?

    Originally posted by ganga
    What SGA size can be set for my new OLTP database?
    Database size going to be 100gb.RAM-4GB ,4-processor ,oracle- 8.1.7 on sun solaris- 8 with SUN Hardware
    This is some pretty old words.
    New 64bit oracle has been support Terabyte sga on 64bit platform.

    The proper sga size depends on the number of connections, ufs or raw, etc.
    www.cnoug.org

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