New Server with 4Gb memory
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: New Server with 4Gb memory

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    New Server with 4Gb memory

    Hi Friends,

    We bought a new IBM AIX Server with 4Gb mem, dual proc
    for our new applications. We will be using oracle 10g.
    We will be having initial users of 100. What will be the size of
    my initial SGA for 100 users?
    If we increase it to 1000 what will be the appropriate SGA?
    Is it dependent of the number of users? or its will just
    dynamically grow and adjust itself (self tuning)

    Thanks a lot

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    are you deploying your application through 10g apps server in this machine alone(single-node)?
    ---------------

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Last edited by davey23uk; 08-11-2006 at 11:39 AM. Reason: Incorrect link
    "What is past is PROLOGUE"

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    IBM AIX Server with 4Gb mem
    Too low for your requirement.

    Tamil

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by tamilselvan
    Too low for your requirement.

    Tamil
    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."

  6. #6
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks for the response

    To papa rey (nabuhay ka, long time no see) ....this box is for the db server only,
    the apps middle tier has its own server.

    To dbasan, sorry i can't access the link anymore :( ...have not
    renewed license maintenance support.

    By the way, if the config is to low for our requirement, how many
    users can be accmodated in this db server then?

    Do I approximate(as rule-of-thumb) that each user will eat-up 4Mb?
    So 4000Mb/4Mb = 1000

    Thanks
    Last edited by yxez; 08-13-2006 at 09:54 PM.

  7. #7
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    hi yxez. your machine is IBM eSeries p Model with AIX 5L o.s. with 4Gbyte mem should just be enough for 100 users. I did have one setup for Oracle Apps 11i(11.5.10) where db server has basically the same with your machine. And it just doing good, I'm not sure though now, if the requirement stays the same. set the sga target at least half of your physical memory and observe it from there.
    ---------------

  8. #8
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Instead of going by approximation,

    SGA= (DB_CACHE_SIZE + DB_KEEP_CACHE_SIZE + DB_RECYCLE_CACHE_SIZE + DB_nk_CACHE_SIZE
    + SHARED_POOL_SIZE + LARGE_POOL_SIZE + JAVA_POOL_SIZE + LOG_BUFFERS)
    "What is past is PROLOGUE"

  9. #9
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857

    Talking

    Quote Originally Posted by dbasan
    Instead of going by approximation,

    SGA= (DB_CACHE_SIZE + DB_KEEP_CACHE_SIZE + DB_RECYCLE_CACHE_SIZE + DB_nk_CACHE_SIZE
    + SHARED_POOL_SIZE + LARGE_POOL_SIZE + JAVA_POOL_SIZE + LOG_BUFFERS)
    So what is your recommendation for SGA according to what info she have gave us so far?
    ---------------

  10. #10
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by reydp
    So what is your recommendation for SGA according to what info she have gave us so far?

    I have given her home work, she would come to know when she does it.
    "What is past is PROLOGUE"

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