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

Thread: Memory

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    Memory

    Hello

    We added couple of Gb more memory to the server.how can i take advantage of that .in other way what parameters should i be incrementing/research to take advantage of the addtional memory added ?


    or how do i tell oracle to use the additional memory where i can improve performance.it's 9i /unix environment

    thank you

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    why did you add memory, what analysis did you do to show you needed more becuase if you had done that then it is obvious where it should be used?

  3. #3
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401
    we are hitting the memory utilized to max during peak times.it's still behaving the same.I wonder do i need to tell oracle we have more memory etc, if so how do i do that

    Thanks

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    so you should know which bit is being exhausted then, what is it, share dpool, buffer cache, pga - which ones are you seeing max utilisation on

  5. #5
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401
    sharedpool and buffer cache

  6. #6
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Well then,
    shared_pool_size
    db_cache_size
    Since you are senior member, I am a bit surprised by this question

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    im curious, how do you know you were filling them up - are you sure you just havent bought memory for the sake of it.

    You know adding more can make things worse?

  8. #8
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    first of all, what was the memory configuration and the init parameters set (those relevent to memory)?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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