Oracle 11g Result Cache Tested on Eight-Way Itanium

Posted in: Technical Track

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 processesBuffer Cache% linearResult Cache% linear

115085100%15451100%
22674588.65%2888193.46%
33914486.5%4062887.65%
45234286.75%5262585.15%
56392284.75%6276781.25%
67633684.34%6954975.02%
78884484.14%7420868.61%
810095983.66%7676862.11%

I made a nice-looking graph from this:

BC vs. RC

The performance drops are quite dramatic. While going from one to two processes can bring us an additional 13430 RC lookups per second, going from seven to eight processes gives us only 2560.

And stats regarding Result Cache: Latch:

# of processesGetsMissesSleepsWait Time

12000001000
2400000210004125137
36000003198365733893164
4800000447330337683330768
5100000059976021311661165493
61200000618386403454873652257
71400000730591477565409915421
8160000084579892143613024922732

Here’s another pretty graph, this time of Result Cache: Latch wait time:

RC Latch Wait

As you can see from the above figures, it only takes six concurrently-running processes before we start observing major issues regarding the Result Set: Latch contention.

Interested in working with Alex? Schedule a tech call.

4 Comments. Leave new

Dominic Brooks
May 7, 2008 3:14 am

Some comments on your test @ Ask Tom:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:676698900346506951

Reply
Alex Fatkulin
May 7, 2008 10:26 am

well, they do explicitly state that they didn’t read the entire thing which I found sort of strange — you supposed to read something before going to comment on it. I leaved my comment to clarify some confusions.

Reply
Oracle 11G Result Cache in the Real World
May 13, 2008 2:46 pm

[…] some of you probably already noticed, there was a thread on AskTom discussing the scalability tests I did back in 2007. You are welcome to read the entire thread, but in a nutshell, Tom Kyte claimed […]

Reply
Result Cache : KMC Data
July 2, 2012 7:17 pm

[…] upshot is that it’s a cool new feature and the problem with the single latch in 11GR1 appears to be solved, but it needs to be heavily load tested before trying it in a production […]

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *