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

Thread: RAM upgrade

  1. #1
    Join Date
    Jun 2006
    Posts
    40

    RAM upgrade

    Hi All,

    If we upgrade the RAM from 1GB to 3 GB on the machine where Oracle is running, What are the things we need to configure in Oracle for better performance?

    Or Oracle will configure itself accrodingly?

    Thanks for your time.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    have you discovered a memory problem which required you to install more memory.

    Allocating more could make things worse

  3. #3
    Join Date
    Jun 2006
    Posts
    40
    In one of our team they have upgraded the RAM, may be because of the performance. After doing this they come to me with this query. I've asked the same thing which you are asking but I didn't get proper reason.
    So I thought to discuss this issue here.

    Please let me know if there are any configuration related to RAM which we've to make after upgrade of RAM.

    Or let me know if there is any material available on net for reading to get the information regarding the same.

    Thanks for your time.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you need to know what the problem was before you can change anything

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Do you have statistics collected before RAM upgrade?

    As Davey said, dont allocate more and get things worse.

    Look into SGA components and justify the allocation, if needed.

    P.S:Oracle will not adjust itself.
    "What is past is PROLOGUE"

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by dbasan
    P.S:Oracle will not adjust itself.
    ...unless you are on 10g and using automatic memory management.
    Jeff Hunter

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