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

eaviles94@yahoo.com wrote in news:1138918380.229667.316390
@g47g2000cwa.googlegroups.com:

>
> My test Oracle database server is performing better than my production
> database server.
>

Quantify "better".


> I've spent much time looking at database stats and tweaking different
> things at the database level but nothing has helped.

What OS & version?
Which version of Oracle to four places?
CBO or RBO?
Are statisics current in production?
Has this performance difference always been the case?
If not, what changed just before the performance got worse.

Ready, Fire, Aim methodology of performance tuning at work here.

Since you don't know exactly what is wrong, you are randomly changing
things while hoping to get lucky & stumble upon the silver bullet.

I suggest that you take a single SQL query which runs noticably slower
in production than on the test system, enable SQL_TRACE at level 12, run
the resultant trace file thru TKPROF & then actually see where the extra
time is being spent

P.S.
More than likely it is NOT the memory.

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@yahoo.com> wrote in message
news:1138918380.229667.316390@g47g2000cwa.googlegr oups.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
>

Hans,

The same batch process runs about 50% faster on the test server.




Hans wrote:
> 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 ?
>

eavile...@yahoo.com wrote:
> Hans,
>
> The same batch process runs about 50% faster on the test server.
>

Cary Millsap's book "Optimizing Oracle Performance" contains a proven
methodology for solving problems like yours. I recommend highly taking
the time to read this book as the primary way of determining how to
attack your problem.

You can get 10046 traces for a representative time of the batch run on
the production server and see what "is slowing it down". Compare and
contrast this with what you see from the batch run on the test server.

I've seen that book referenced in so many plances that I placed an
order on Amazon.

Still, my original question remains unanswered. Given the interleave
factor difference, how much impact would that have on memory intensive
database queries? Is it negligible or is it a big deal?

Thanks.



hpuxrac wrote:
> eavile...@yahoo.com wrote:
> > Hans,
> >
> > The same batch process runs about 50% faster on the test server.
> >
>
> Cary Millsap's book "Optimizing Oracle Performance" contains a proven
> methodology for solving problems like yours. I recommend highly taking
> the time to read this book as the primary way of determining how to
> attack your problem.
>
> You can get 10046 traces for a representative time of the batch run on
> the production server and see what "is slowing it down". Compare and
> contrast this with what you see from the batch run on the test server.

It is a BIG deal. Having 8-way interleave, instead of 16, can reduce
the peak memory bandwidth by half. And you're running a database
workload where memory bandwidth is critical (well, nowadays, many
commercial workloads are either memory bandwidth bound or memory
latency bound or both - no wonder UltraSPARC T1 performs well given its
low latency and high peak bandwidth).

-Seongbae, usually as seongbae.park@sun.com

eaviles94@yahoo.com wrote:
> I've seen that book referenced in so many plances that I placed an
> order on Amazon.
>
> Still, my original question remains unanswered. Given the interleave
> factor difference, how much impact would that have on memory intensive
> database queries? Is it negligible or is it a big deal?
>

It can be a big deal if your queries are CPU limited.
It can be nothing if your bottleneck is instead IO.
Hence the request to go through Cary's approach with
10046: it will tell you exactly what's going on and where
to look for problems.

Interleave can be a big factor for cpu intensive work,
be it database or anything else. Try to get a memory
speed test program and do some comparative tests.

In comp.sys.sun.hardware eaviles94@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.

The way I understand it, if you want one BIG domain on your system, then
performance wise a single domain 6800 will be better than a 15K containing
the same number of system boards.