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