-
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. ?
-
Originally Posted by pascal01
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|