Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Interleave factor performance impact

Re: Interleave factor performance impact

From: Scott Howard <scott_at_hunterlink.net.au>
Date: Sat, 4 Feb 2006 13:30:56 +0000 (UTC)
Message-ID: <1139059856.200256@docbert>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US