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: Hans <nospam_at_nospam.se>
Date: Fri, 3 Feb 2006 14:09:38 +0100
Message-ID: <drvkmj$95v$1@news.al.sw.ericsson.se>


Interesting !
I have also noted wildly different interleave configurations on different machines for no obvious reason.
Do you have any numbers on the performance difference in your application ?

<eaviles94_at_yahoo.com> wrote in message
news:1138918380.229667.316390_at_g47g2000cwa.googlegroups.com...
>
> My test Oracle database server is performing better than my production
> database server.
>
> I've spent much time looking at database stats and tweaking different
> things at the database level but nothing has helped.
>
> 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.
>
> How much impact does the interleave factor has on performance?
>
> Here's the prtdiag output for both servers.
>
> TEST SERVER:
>
> /usr/platform/sun4u/sbin/prtdiag -v
>
> System Configuration: Sun Microsystems sun4u Sun Fire 6800
> System clock frequency: 150 MHz
> Memory size: 32768 Megabytes
>
> ========================= CPUs
> ===============================================
>
> CPU Run E$ CPU CPU
> FRU Name ID MHz MB Impl. Mask
> ---------- ------- ---- ---- ------- ----
> /N0/SB1/P0 4 1200 8.0 US-III+ 11.0
> /N0/SB1/P1 5 1200 8.0 US-III+ 11.0
> /N0/SB1/P2 6 1200 8.0 US-III+ 11.0
> /N0/SB1/P3 7 1200 8.0 US-III+ 11.0
> /N0/SB3/P0 12 1200 8.0 US-III+ 11.0
> /N0/SB3/P1 13 1200 8.0 US-III+ 11.0
> /N0/SB3/P2 14 1200 8.0 US-III+ 11.0
> /N0/SB3/P3 15 1200 8.0 US-III+ 11.0
> /N0/SB5/P0 20 1200 8.0 US-III+ 11.0
> /N0/SB5/P1 21 1200 8.0 US-III+ 11.0
> /N0/SB5/P2 22 1200 8.0 US-III+ 11.0
> /N0/SB5/P3 23 1200 8.0 US-III+ 11.0
>
> ========================= Memory Configuration
> ===============================
>
> Logical Logical Logical
> Port Bank Bank Bank DIMM Interleave
> Interleave
> FRU Name ID Num Size Status Size Factor
> Segment
> ------------- ---- ---- ------ ----------- ------ ----------
> ----------
> /N0/SB1/P0/B0 4 0 512MB pass 256MB 16-way
> 0
> /N0/SB1/P0/B1 4 1 512MB pass 256MB 16-way
> 0
> /N0/SB1/P0/B0 4 2 512MB pass 256MB 16-way
> 0
> /N0/SB1/P0/B1 4 3 512MB pass 256MB 16-way
> 0
> /N0/SB1/P1/B0 5 0 512MB pass 256MB 16-way
> 0
> /N0/SB1/P1/B1 5 1 512MB pass 256MB 16-way
> 0
> /N0/SB1/P1/B0 5 2 512MB pass 256MB 16-way
> 0
> /N0/SB1/P1/B1 5 3 512MB pass 256MB 16-way
> 0
> /N0/SB1/P2/B0 6 0 512MB pass 256MB 16-way
> 0
> /N0/SB1/P2/B1 6 1 512MB pass 256MB 16-way
> 0
> /N0/SB1/P2/B0 6 2 512MB pass 256MB 16-way
> 0
> /N0/SB1/P2/B1 6 3 512MB pass 256MB 16-way
> 0
> /N0/SB1/P3/B0 7 0 512MB pass 256MB 16-way
> 0
> /N0/SB1/P3/B1 7 1 512MB pass 256MB 16-way
> 0
> /N0/SB1/P3/B0 7 2 512MB pass 256MB 16-way
> 0
> /N0/SB1/P3/B1 7 3 512MB pass 256MB 16-way
> 0
> /N0/SB3/P0/B0 12 0 512MB pass 256MB 16-way
> 1
> /N0/SB3/P0/B1 12 1 512MB pass 256MB 16-way
> 1
> /N0/SB3/P0/B0 12 2 512MB pass 256MB 16-way
> 1
> /N0/SB3/P0/B1 12 3 512MB pass 256MB 16-way
> 1
> /N0/SB3/P1/B0 13 0 512MB pass 256MB 16-way
> 1
> /N0/SB3/P1/B1 13 1 512MB pass 256MB 16-way
> 1
> /N0/SB3/P1/B0 13 2 512MB pass 256MB 16-way
> 1
> /N0/SB3/P1/B1 13 3 512MB pass 256MB 16-way
> 1
> /N0/SB3/P2/B0 14 0 512MB pass 256MB 16-way
> 1
> /N0/SB3/P2/B1 14 1 512MB pass 256MB 16-way
> 1
> /N0/SB3/P2/B0 14 2 512MB pass 256MB 16-way
> 1
> /N0/SB3/P2/B1 14 3 512MB pass 256MB 16-way
> 1
> /N0/SB3/P3/B0 15 0 512MB pass 256MB 16-way
> 1
> /N0/SB3/P3/B1 15 1 512MB pass 256MB 16-way
> 1
> /N0/SB3/P3/B0 15 2 512MB pass 256MB 16-way
> 1
> /N0/SB3/P3/B1 15 3 512MB pass 256MB 16-way
> 1
> /N0/SB5/P0/B0 20 0 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P0/B1 20 1 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P0/B0 20 2 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P0/B1 20 3 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P1/B0 21 0 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P1/B1 21 1 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P1/B0 21 2 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P1/B1 21 3 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P2/B0 22 0 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P2/B1 22 1 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P2/B0 22 2 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P2/B1 22 3 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P3/B0 23 0 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P3/B1 23 1 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P3/B0 23 2 1024MB pass 512MB 16-way
> 2
> /N0/SB5/P3/B1 23 3 1024MB pass 512MB 16-way
> 2
>
>
> PRODUCTION SERVER:
>
> /usr/platform/sun4u/sbin/prtdiag -v | more
>
> System Configuration: Sun Microsystems sun4u Sun Fire 15K
> System clock frequency: 150 MHz
> Memory size: 57344 Megabytes
>
> ========================= CPUs =========================
>
> CPU Run E$ CPU CPU
> Slot ID ID MHz MB Impl. Mask
> -------- ------- ---- ---- ------- ----
> /SB00/P0 0 1200 8.0 US-III+ 11.0
> /SB00/P1 1 1200 8.0 US-III+ 11.0
> /SB00/P2 2 1200 8.0 US-III+ 11.0
> /SB00/P3 3 1200 8.0 US-III+ 11.0
> /SB01/P0 32 1200 8.0 US-III+ 11.0
> /SB01/P1 33 1200 8.0 US-III+ 11.0
> /SB01/P2 34 1200 8.0 US-III+ 11.0
> /SB01/P3 35 1200 8.0 US-III+ 11.0
> /SB02/P0 64 1200 8.0 US-III+ 11.0
> /SB02/P1 65 1200 8.0 US-III+ 11.0
> /SB02/P2 66 1200 8.0 US-III+ 11.0
> /SB02/P3 67 1200 8.0 US-III+ 11.0
> /SB14/P0 448 1200 8.0 US-III+ 11.0
> /SB14/P1 449 1200 8.0 US-III+ 11.0
> /SB14/P2 450 1200 8.0 US-III+ 11.0
> /SB14/P3 451 1200 8.0 US-III+ 11.0
>
> ========================= Memory Configuration
> =========================
>
> Logical Logical Logical
> Port Bank Bank Bank DIMM Interleave
> Interleave
> Slot ID ID Number Size Status Size Factor
> Segment
> ----------- ---- ------- ------- -------- ------ ----------
> ----------
> /SB00/P0/B0 0 0 1024MB okay 512MB 8-way
> 0
> /SB00/P0/B0 0 2 1024MB okay 512MB 8-way
> 0
> /SB00/P1/B0 1 0 1024MB okay 512MB 8-way
> 0
> /SB00/P1/B0 1 2 1024MB okay 512MB 8-way
> 0
> /SB00/P2/B0 2 0 1024MB okay 512MB 8-way
> 0
> /SB00/P2/B0 2 2 1024MB okay 512MB 8-way
> 0
> /SB00/P3/B0 3 0 1024MB okay 512MB 8-way
> 0
> /SB00/P3/B0 3 2 1024MB okay 512MB 8-way
> 0
> /SB01/P0/B0 32 0 1024MB okay 512MB 8-way
> 1
> /SB01/P0/B0 32 2 1024MB okay 512MB 8-way
> 1
> /SB01/P1/B0 33 0 1024MB okay 512MB 8-way
> 1
> /SB01/P1/B0 33 2 1024MB okay 512MB 8-way
> 1
> /SB01/P2/B0 34 0 1024MB okay 512MB 8-way
> 1
> /SB01/P2/B0 34 2 1024MB okay 512MB 8-way
> 1
> /SB01/P3/B0 35 0 1024MB okay 512MB 8-way
> 1
> /SB01/P3/B0 35 2 1024MB okay 512MB 8-way
> 1
> /SB02/P0/B0 64 0 2048MB okay 1024MB 16-way
> 2
> /SB02/P0/B1 64 1 2048MB okay 1024MB 16-way
> 2
> /SB02/P0/B0 64 2 2048MB okay 1024MB 16-way
> 2
> /SB02/P0/B1 64 3 2048MB okay 1024MB 16-way
> 2
> /SB02/P1/B0 65 0 2048MB okay 1024MB 16-way
> 2
> /SB02/P1/B1 65 1 2048MB okay 1024MB 16-way
> 2
> /SB02/P1/B0 65 2 2048MB okay 1024MB 16-way
> 2
> /SB02/P1/B1 65 3 2048MB okay 1024MB 16-way
> 2
> /SB02/P2/B0 66 0 2048MB okay 1024MB 16-way
> 2
> /SB02/P2/B1 66 1 2048MB okay 1024MB 16-way
> 2
> /SB02/P2/B0 66 2 2048MB okay 1024MB 16-way
> 2
> /SB02/P2/B1 66 3 2048MB okay 1024MB 16-way
> 2
> /SB02/P3/B0 67 0 2048MB okay 1024MB 16-way
> 2
> /SB02/P3/B1 67 1 2048MB okay 1024MB 16-way
> 2
> /SB02/P3/B0 67 2 2048MB okay 1024MB 16-way
> 2
> /SB02/P3/B1 67 3 2048MB okay 1024MB 16-way
> 2
> /SB14/P0/B0 448 0 1024MB okay 512MB 8-way
> 3
> /SB14/P0/B0 448 2 1024MB okay 512MB 8-way
> 3
> /SB14/P1/B0 449 0 1024MB okay 512MB 8-way
> 3
> /SB14/P1/B0 449 2 1024MB okay 512MB 8-way
> 3
> /SB14/P2/B0 450 0 1024MB okay 512MB 8-way
> 3
> /SB14/P2/B0 450 2 1024MB okay 512MB 8-way
> 3
> /SB14/P3/B0 451 0 1024MB okay 512MB 8-way
> 3
> /SB14/P3/B0 451 2 1024MB okay 512MB 8-way
> 3
>
Received on Fri Feb 03 2006 - 07:09:38 CST

Original text of this message

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