Automatic Shared Memory Questions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Automatic Shared Memory Questions

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218

    Question Automatic Shared Memory Questions

    I had an oltp database where the total SGA=2G. 500M for shared pool, 1000M for db_cache, 500M for the rest of the buffers. I turned on ASM and set the SGA_Target to 2G as before. How does oracle manage the percentage of the buffer pool vs shared pool and the rest of the pools. ?

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by pascal01 View Post
    How does oracle manage the percentage of the buffer pool vs shared pool and the rest of the pools. ?
    Actual algorithm might be propietary information but link next is a good starting point to get a glimpse of how it works: http://www.datadisk.co.uk/html_docs/oracle/asmm.htm
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218
    Good link. Thanks

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