- 论坛徽章:
- 0
|
现有一台Sun 6800 配置为:
System Configuration: Sun Microsystems sun4u Sun Fire 6800
?μí3ê±?ó?μ?ê£o150 MHz
?ú′?′óD?£o12288 ?××??ú
========================= CPUs ===============================================
CPU Run E$ CPU CPU
FRU Name ID MHz MB Impl. Mask
---------- ------- ---- ---- ------- ----
/N0/SB1/P0 4 900 8.0 US-III+ 2.3
/N0/SB1/P1 5 900 8.0 US-III+ 2.3
/N0/SB1/P2 6 900 8.0 US-III+ 2.3
/N0/SB1/P3 7 900 8.0 US-III+ 2.3
/N0/SB3/P0 12 900 8.0 US-III+ 2.3
/N0/SB3/P1 13 900 8.0 US-III+ 2.3
/N0/SB3/P2 14 900 8.0 US-III+ 2.3
/N0/SB3/P3 15 900 8.0 US-III+ 2.3
/N0/SB5/P0 20 900 8.0 US-III+ 2.3
/N0/SB5/P1 21 900 8.0 US-III+ 2.3
/N0/SB5/P2 22 900 8.0 US-III+ 2.3
/N0/SB5/P3 23 900 8.0 US-III+ 2.3
========================= 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 8-way 0
/N0/SB1/P0/B0 4 2 512MB pass 256MB 8-way 0
/N0/SB1/P1/B0 5 0 512MB pass 256MB 8-way 0
/N0/SB1/P1/B0 5 2 512MB pass 256MB 8-way 0
/N0/SB1/P2/B0 6 0 512MB pass 256MB 8-way 0
/N0/SB1/P2/B0 6 2 512MB pass 256MB 8-way 0
/N0/SB1/P3/B0 7 0 512MB pass 256MB 8-way 0
/N0/SB1/P3/B0 7 2 512MB pass 256MB 8-way 0
/N0/SB3/P0/B0 12 0 512MB pass 256MB 8-way 1
/N0/SB3/P0/B0 12 2 512MB pass 256MB 8-way 1
/N0/SB3/P1/B0 13 0 512MB pass 256MB 8-way 1
/N0/SB3/P1/B0 13 2 512MB pass 256MB 8-way 1
/N0/SB3/P2/B0 14 0 512MB pass 256MB 8-way 1
/N0/SB3/P2/B0 14 2 512MB pass 256MB 8-way 1
/N0/SB3/P3/B0 15 0 512MB pass 256MB 8-way 1
/N0/SB3/P3/B0 15 2 512MB pass 256MB 8-way 1
/N0/SB5/P0/B0 20 0 512MB pass 256MB 8-way 2
/N0/SB5/P0/B0 20 2 512MB pass 256MB 8-way 2
/N0/SB5/P1/B0 21 0 512MB pass 256MB 8-way 2
/N0/SB5/P1/B0 21 2 512MB pass 256MB 8-way 2
/N0/SB5/P2/B0 22 0 512MB pass 256MB 8-way 2
/N0/SB5/P2/B0 22 2 512MB pass 256MB 8-way 2
/N0/SB5/P3/B0 23 0 512MB pass 256MB 8-way 2
/N0/SB5/P3/B0 23 2 512MB pass 256MB 8-way 2
========================= IO ?¨ =========================
Bus Max
IO Port Bus Freq Bus Dev,
FRU Name Type ID Side Slot MHz Freq Func State Name Model
---------- ---- ---- ---- ---- ---- ---- ---- ----- -------------------------------- ----------------------
/N0/IB6/P0 PCI 24 B 0 33 33 1,0 ok pci-pci8086,b152.0/pci108e,1000 pci-bridge
/N0/IB6/P0 PCI 24 B 0 33 33 0,0 ok pci108e,1000-pci108e,1000.1
/N0/IB6/P0 PCI 24 B 0 33 33 0,1 ok SUNW,hme-pci108e,1001 SUNW,cheerio
/N0/IB6/P0 PCI 24 B 0 33 33 4,0 ok SUNW,isptwo-pci1077,1020/sd (blo+ QLGC,ISP1040B
/N0/IB6/P0 PCI 24 A 3 66 66 1,0 ok SUNW,qlc-pci1077,2200.1077.4082.+
/N0/IB6/P1 PCI 25 B 4 33 33 1,0 ok pci-pci8086,b152.0/pci108e,1000 pci-bridge
/N0/IB6/P1 PCI 25 B 4 33 33 0,0 ok pci108e,1000-pci108e,1000.1
/N0/IB6/P1 PCI 25 B 4 33 33 0,1 ok SUNW,hme-pci108e,1001 SUNW,cheerio
/N0/IB6/P1 PCI 25 B 4 33 33 4,0 ok SUNW,isptwo-pci1077,1020/sd (blo+ QLGC,ISP1040B
/N0/IB6/P1 PCI 25 A 7 66 66 1,0 ok SUNW,qlc-pci1077,2200.1077.4082.+
========================= í?óòμ??¤??°? ===========================
Power Fault HotPlug Board
FRU Name LED LED LED Cond.
-------- ----- ----- ------- -------
/N0/SB1 on off off ok
/N0/SB3 on off off ok
/N0/SB5 on off off ok
/N0/IB6 on off off ok
/N0/IB7 on off off ok
/N0/IB8 on off off ok
/N0/IB9 on off off ok
========================= í?óòμ??¤??°?/????2? ==================
Power Fault HotPlug Board/Slot Board/Slot
FRU Name LED LED LED Condition Assigned
-------- ----- ----- ------- ---------- ----------
/SB0 off off off Empty yes
/SB2 off off off Empty yes
/SB4 off off off Empty yes
========================= ó2?t1ê?? ==================================
?μí3?D?′·¢??ó2?t1ê??
========================= HW DT?? =======================================
System PROM revisions:
----------------------
OBP 5.15.3 09/30/03 23:01
IO ASIC revisions:
------------------
Port
FRU Name Model ID Status Version
----------- --------------- ---- ------ -------
/N0/IB6/P0 SUNW,schizo 24 ok 4
/N0/IB6/P1 SUNW,schizo 25 ok 4
/N0/IB7/P0 SUNW,schizo 26 ok 4
/N0/IB7/P1 SUNW,schizo 27 ok 4
/N0/IB8/P0 SUNW,schizo 28 ok 4
/N0/IB8/P1 SUNW,schizo 29 ok 4
/N0/IB9/P0 SUNW,schizo 30 ok 4
/N0/IB9/P1 SUNW,schizo 31 ok 4
/N0/IB6/P0 SUNW,sgsbbc 24 ok 2
/N0/IB7/P0 SUNW,sgsbbc 26 ok 2
/N0/IB8/P0 SUNW,sgsbbc 28 ok 2
/N0/IB9/P0 SUNW,sgsbbc 30 ok 2
用户提出数据库运行速度慢,而其DBA对数据库进行过优化后,对性能没有大的提高和改善,所以用户希望能够检查是否存在硬件问题。
该机器设备上只运行了一个Oracle数据库.
用sar -d 2 10 和 sar -b 2 10,sar -u 2 10检查
root@NMC-DBS-1 # sar -d 2 10
SunOS NMC-DBS-1 5.8 Generic_117350-02 sun4u 06/06/07
18:37:11 device %busy avque r+w/s blks/s avwait avserv
18:37:13 ssd4.fp0 0 0.0 0 0 0.0 0.0
ssd4.fp1 0 0.0 219 32877 0.0 0.0
ssd5.fp0 0 0.0 0 0 0.0 0.0
ssd5.fp1 0 0.0 457 21395 0.0 0.0
nfs1 0 0.0 0 0 0.0 0.0
sd0 1 0.0 2 24 0.0 6.2
sd0,a 0 0.0 0 0 0.0 0.0
sd0,b 0 0.0 0 0 0.0 0.0
sd0,c 0 0.0 0 0 0.0 0.0
sd0,d 1 0.0 2 24 0.0 6.2
sd0,e 0 0.0 0 0 0.0 0.0
sd1 1 0.0 2 24 0.0 7.6
sd1,a 0 0.0 0 0 0.0 0.0
sd1,b 0 0.0 0 0 0.0 0.0
sd1,c 0 0.0 0 0 0.0 0.0
sd1,d 0 0.0 0 0 0.0 0.0
sd1,e 1 0.0 2 24 0.0 7.6
sd6 0 0.0 0 0 0.0 0.0
ssd4 97 34.9 219 32877 80.8 78.7
ssd4,c 0 0.0 0 0 0.0 0.0
ssd4,d 0 0.0 0 0 0.0 0.0
ssd4,e 97 34.9 219 32877 80.8 78.7
ssd5 100 101.4 457 21396 158.7 63.3
ssd5,c 0 0.0 0 0 0.0 0.0
ssd5,d 0 0.0 0 0 0.0 0.0
ssd5,e 100 101.4 457 21396 158.7 63.3
st4 0 0.0 0 0 0.0 0.0
st14 0 0.0 0 0 0.0 0.0
st15 0 0.0 0 0 0.0 0.0
18:37:15 ssd4.fp0 0 0.0 0 0 0.0 0.0
ssd4.fp1 0 0.0 602 19814 0.0 0.0
ssd5.fp0 0 0.0 0 0 0.0 0.0
ssd5.fp1 0 0.0 666 16551 0.0 0.0
nfs1 0 0.0 0 0 0.0 0.0
sd0 0 0.0 0 0 0.0 0.0
sd0,a 0 0.0 0 0 0.0 0.0
sd0,b 0 0.0 0 0 0.0 0.0
sd0,c 0 0.0 0 0 0.0 0.0
sd0,d 0 0.0 0 0 0.0 0.0
sd0,e 0 0.0 0 0 0.0 0.0
sd1 0 0.0 0 0 0.0 0.0
sd1,a 0 0.0 0 0 0.0 0.0
sd1,b 0 0.0 0 0 0.0 0.0
sd1,c 0 0.0 0 0 0.0 0.0
sd1,d 0 0.0 0 0 0.0 0.0
sd1,e 0 0.0 0 0 0.0 0.0
sd6 0 0.0 0 0 0.0 0.0
ssd4 99 333.5 602 19814 467.5 86.3
ssd4,c 0 0.0 0 0 0.0 0.0
ssd4,d 0 0.0 0 0 0.0 0.0
ssd4,e 99 333.5 602 19814 467.5 86.3
ssd5 100 355.6 666 16551 453.9 79.9
ssd5,c 0 0.0 0 0 0.0 0.0
ssd5,d 0 0.0 0 0 0.0 0.0
ssd5,e 100 355.6 666 16551 453.9 79.9
st4 0 0.0 0 0 0.0 0.0
st14 0 0.0 0 0 0.0 0.0
st15 0 0.0 0 0 0.0 0.0
18:37:17 ssd4.fp0 0 0.0 0 0 0.0 0.0
ssd4.fp1 0 0.0 120 15609 0.0 0.0
ssd5.fp0 0 0.0 0 0 0.0 0.0
ssd5.fp1 0 0.0 302 35060 0.0 0.0
nfs1 0 0.0 0 0 0.0 0.0
sd0 0 0.0 0 0 0.0 0.0
sd0,a 0 0.0 0 0 0.0 0.0
sd0,b 0 0.0 0 0 0.0 0.0
sd0,c 0 0.0 0 0 0.0 0.0
sd0,d 0 0.0 0 0 0.0 0.0
sd0,e 0 0.0 0 0 0.0 0.0
sd1 0 0.0 0 0 0.0 0.0
sd1,a 0 0.0 0 0 0.0 0.0
sd1,b 0 0.0 0 0 0.0 0.0
sd1,c 0 0.0 0 0 0.0 0.0
sd1,d 0 0.0 0 0 0.0 0.0
sd1,e 0 0.0 0 0 0.0 0.0
sd6 0 0.0 0 0 0.0 0.0
ssd4 95 1.8 120 15609 0.0 15.0
ssd4,c 0 0.0 0 0 0.0 0.0
ssd4,d 0 0.0 0 0 0.0 0.0
ssd4,e 95 1.8 120 15609 0.0 15.0
ssd5 100 8.3 302 35060 0.0 27.3
ssd5,c 0 0.0 0 0 0.0 0.0
ssd5,d 0 0.0 0 0 0.0 0.0
ssd5,e 100 8.3 302 35060 0.0 27.3
st4 0 0.0 0 0 0.0 0.0
st14 0 0.0 0 0 0.0 0.0
st15 0 0.0 0 0 0.0 0.0
18:37:19 ssd4.fp0 0 0.0 0 0 0.0 0.0
ssd4.fp1 0 0.0 97 6858 0.0 0.0
ssd5.fp0 0 0.0 0 0 0.0 0.0
ssd5.fp1 0 0.0 369 41550 0.0 0.0
nfs1 0 0.0 0 0 0.0 0.0
sd0 10 0.1 19 83 0.0 5.8
sd0,a 0 0.0 0 0 0.0 0.0
sd0,b 0 0.0 0 0 0.0 0.0
sd0,c 0 0.0 0 0 0.0 0.0
sd0,d 10 0.1 19 83 0.0 5.8
sd0,e 0 0.0 0 0 0.0 0.0
sd1 6 0.1 19 83 0.0 3.4
sd1,a 0 0.0 0 0 0.0 0.0
sd1,b 0 0.0 0 0 0.0 0.0
sd1,c 0 0.0 0 0 0.0 0.0
sd1,d 0 0.0 0 0 0.0 0.0
sd1,e 6 0.1 19 83 0.0 3.4
sd6 0 0.0 0 0 0.0 0.0
ssd4 67 3.0 97 6858 0.0 31.2
ssd4,c 0 0.0 0 0 0.0 0.0
ssd4,d 0 0.0 0 0 0.0 0.0
ssd4,e 67 3.0 97 6858 0.0 31.2
ssd5 100 11.9 369 41550 2.3 30.0
ssd5,c 0 0.0 0 0 0.0 0.0
ssd5,d 0 0.0 0 0 0.0 0.0
ssd5,e 100 11.9 369 41550 2.3 30.0
st4 0 0.0 0 0 0.0 0.0
st14 0 0.0 0 0 0.0 0.0
st15 0 0.0 0 0 0.0 0.0
18:37:21 ssd4.fp0 0 0.0 0 0 0.0 0.0
ssd4.fp1 0 0.0 79 6284 0.0 0.0
ssd5.fp0 0 0.0 0 0 0.0 0.0
ssd5.fp1 0 0.0 323 47506 0.0 0.0
nfs1 0 0.0 0 0 0.0 0.0
sd0 23 0.6 37 422 0.0 15.2
sd0,a 0 0.0 0 0 0.0 0.0
sd0,b 0 0.0 0 0 0.0 0.0
sd0,c 0 0.0 0 0 0.0 0.0
sd0,d 23 0.6 37 422 0.0 15.2
sd0,e 0 0.0 0 0 0.0 0.0
sd1 20 0.6 30 303 0.0 20.8
sd1,a 0 0.0 0 0 0.0 0.0
sd1,b 0 0.0 0 0 0.0 0.0
sd1,c 0 0.0 0 0 0.0 0.0
sd1,d 0 0.0 0 0 0.0 0.0
sd1,e 20 0.6 30 303 0.0 20.8
sd6 0 0.0 0 0 0.0 0.0
ssd4 74 1.3 79 6284 0.0 16.0
ssd4,c 0 0.0 0 0 0.0 0.0
ssd4,d 0 0.0 0 0 0.0 0.0
ssd4,e 74 1.3 79 6284 0.0 16.0
ssd5 100 8.5 323 47506 0.0 26.4
ssd5,c 0 0.0 0 0 0.0 0.0
ssd5,d 0 0.0 0 0 0.0 0.0
ssd5,e 100 8.5 323 47506 0.0 26.4
st4 0 0.0 0 0 0.0 0.0
st14 0 0.0 0 0 0.0 0.0
st15 0 0.0 0 0 0.0 0.0
18:37:23 ssd4.fp0 0 0.0 0 0 0.0 0.0
ssd4.fp1 0 0.0 76 4034 0.0 0.0
ssd5.fp0 0 0.0 0 0 0.0 0.0
ssd5.fp1 0 0.0 326 43817 0.0 0.0
nfs1 0 0.0 0 0 0.0 0.0
sd0 1 0.0 1 29 0.0 9.0
sd0,a 0 0.0 0 0 0.0 0.0
sd0,b 0 0.0 0 0 0.0 0.0
sd0,c 0 0.0 0 0 0.0 0.0
sd0,d 1 0.0 1 29 0.0 9.0
sd0,e 0 0.0 0 0 0.0 0.0
sd1 1 0.0 1 29 0.0 9.9
sd1,a 0 0.0 0 0 0.0 0.0
sd1,b 0 0.0 0 0 0.0 0.0
sd1,c 0 0.0 0 0 0.0 0.0
sd1,d 0 0.0 0 0 0.0 0.0
sd1,e 1 0.0 1 29 0.0 9.9
sd6 0 0.0 0 0 0.0 0.0
ssd4 71 1.1 76 4034 0.0 14.6
ssd4,c 0 0.0 0 0 0.0 0.0
ssd4,d 0 0.0 0 0 0.0 0.0
ssd4,e 71 1.1 76 4034 0.0 14.6
ssd5 100 8.7 326 43817 0.0 26.7
ssd5,c 0 0.0 0 0 0.0 0.0
ssd5,d 0 0.0 0 0 0.0 0.0
ssd5,e 100 8.7 326 43817 0.0 26.7
st4 0 0.0 0 0 0.0 0.0
st14 0 0.0 0 0 0.0 0.0
st15 0 0.0 0 0 0.0 0.0 |
|