Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Interleave factor performance impact
In comp.sys.sun.hardware eaviles94_at_yahoo.com wrote:
> My test Oracle database server is performing better than my production
> database server.
>
> One thing I noticed between the two servers is that the test box has
> all memory 16-way interleaved while the production box has a mix of
> 8-way and 16-way. I looked at memory configuration after I found memory
> intensive queries ran faster on test.
One thing I noticed is that one is a 6800 and the other is a 15K. These are _very_ different beasts that work in very different ways. (6800 is snoopy coherency, F15K is ccNUMA)
There's far too many variables in the platform difference alone to start with memory...
Scott. Received on Sat Feb 04 2006 - 07:30:56 CST