Oracle 11g Result Cache Tested on Eight-Way Itanium
Posted by Alex Fatkulin on Nov 27, 2007
This will be the final post in my series on Result Caches. In my previous article, I had already got almost everything. Almost — four CPUs (cores) were still not enough to saturate the single latch. As you’ve probably already guessed, today we are going with an eight-way test.
Please note that today’s numbers are different since I’m using an entirely different hardware platform. While the four-way tests were done on a 2.4GHz Core 2 Quad box, today’s eight-way tests were done using four dual core Itanium 2 CPUs running at 1.1GHz.
Let’s take a look at the results:
| # of processes | Buffer Cache | % linear | Result Cache | % linear |
|---|---|---|---|---|
| 1 | 15085 | 100% | 15451 | 100% |
| 2 | 26745 | 88.65% | 28881 | 93.46% |
| 3 | 39144 | 86.5% | 40628 | 87.65% |
| 4 | 52342 | 86.75% | 52625 | 85.15% |
| 5 | 63922 | 84.75% | 62767 | 81.25% |
| 6 | 76336 | 84.34% | 69549 | 75.02% |
| 7 | 88844 | 84.14% | 74208 | 68.61% |
| 8 | 100959 | 83.66% | 76768 | 62.11% |
I made a nice-looking graph from this:
