Re: I think our overlapping responses are getting confusedMarch 19 2012 at 3:52 PM
No score for this post
|Tim Faitsch |
from IP address 18.104.22.168
Response to I think our overlapping responses are getting confused
There's a lot to discuss here:
1. Let's not bring Exalytics into the equation yet -- at this point I'm going to withhold comments for various reasons...
2. I've tested large ASO models and have seen no benefit in allocating more cache than is recommended by the DBA Guide. I'd love to see the cube that proves otherwise. The bottom line is that cache in ASO isn't very important.
"A 32 MB cache setting supports a database with approximately 2 GB of input-level data. If the
input-level data size is greater than 2 GB by some factor, the aggregate storage cache can be
increased by the square root of the factor. For example, if the input-level data size is 3 GB
(2 GB * 1.5), multiply the aggregate storage cache size of 32 MB by the square root of 1.5, and
set the aggregate cache size to the result: 39.04 MB."
So the equation is this:
SQRT((Input Size in GB/2)) * 32
Input Size/Recommended Cache Size
- Agree on ASO Cache Size but that was not the question - DanP on Mar 19, 2012, 5:46 PM
- Re: Agree on ASO Cache Size but that was not the question - Tim Faitsch on Mar 20, 2012, 7:37 AM