In the previous post I explained how to list Exadata disk layout and topology details with the exadisktopo scripts, in this post I’ll introduce one celldisk overview script, which I use to quickly see the celldisk configuration, specs and error statuses. The cellpd.sql script (Cell Physical Disk) will show the following output:
SQL> @exadata/cellpd.sql
Show Exadata cell versions from V$CELL_CONFIG....
DISKTYPE CELLNAME STATUS TOTAL_GB AVG_GB NUM_DISKS PREDFAIL POORPERF WTCACHEPROB PEERFAIL CRITICAL
-------------------- -------------------- -------------------- ---------- ---------- ---------- ---------- ---------- ----------- ---------- ----------
FlashDisk 192.168.12.3 normal 183 23 8
FlashDisk 192.168.12.3 not present 183 23 8 3
FlashDisk 192.168.12.4 normal 366 23 16
FlashDisk 192.168.12.5 normal 366 23 16
HardDisk 192.168.12.3 normal 22352 1863 12
HardDisk 192.168.12.4 normal 22352 1863 12
HardDisk 192.168.12.5 normal 22352 1863 12
Above you see that some of my Flash Disks are missing and before they went completely missing (because the Oracle Ninja removed them :) these disks indicated the “poor performance” status.
The cellpdx.sql script will display extended info for each celldisk, including disk model, firmware version, serial number and various error metrics. Warning, lots of wide output coming again:
SQL> @exadata/cellpdx.sql Show Exadata cell versions from V$CELL_CONFIG.... CELLNAME DISKNAME DISKTYPE LUNS MAKEMODEL PHYSICALFIRMWARE PHYSICALINSERTTIME PHYSICALSERIAL PHYSICALSIZE SECTORREMAPCOUNT SLOTNUMBER STATUS ID KEY_500 PREDFAILSTATUS POORPERFSTATUS WTCACHINGSTATUS PEERFAILSTATUS CRITICALSTATUS ERRCMDTIMEOUTCOUNT ERRHARDREADCOUNT ERRHARDWRITECOUNT ERRMEDIACOUNT ERROTHERCOUNT ERRSEEKCOUNT -------------------- -------------------- -------------------- -------------------- ---------------------------------------- -------------------- ------------------------------ -------------------- -------------------- -------------------- ------------------------------ -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- 192.168.12.3 35:0 HardDisk 0_0 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2013-02-07T10:50:29-06:00 JK11D1YAJTXVMZ 2000011650924 0 normal JK11D1YAJTXVMZ DMG_SYSTEM_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.3 35:1 HardDisk 0_1 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:10:46-05:00 JK11D1YAJB4V0Z 2000011650924 1 normal JK11D1YAJB4V0Z DMG_SYSTEM_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.3 35:10 HardDisk 0_10 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2013-02-07T10:52:02-06:00 JK11D1YAJM5X9Z 2000011650924 10 normal JK11D1YAJM5X9Z DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.3 35:11 HardDisk 0_11 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:10:59-05:00 JK11D1YAJAZNKZ 2000011650924 11 normal JK11D1YAJAZNKZ DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.3 35:2 HardDisk 0_2 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:10:47-05:00 JK11D1YAJAZMMZ 2000011650924 2 normal JK11D1YAJAZMMZ DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.3 35:3 HardDisk 0_3 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:10:49-05:00 JK11D1YAJ7JX2Z 2000011650924 3 normal JK11D1YAJ7JX2Z DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.3 35:4 HardDisk 0_4 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2012-03-01T15:31:04-06:00 JK11D1YAJB3J1Z 2000011650924 4 normal JK11D1YAJB3J1Z DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.3 35:5 HardDisk 0_5 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:10:51-05:00 JK11D1YAJB4J8Z 2000011650924 5 normal JK11D1YAJB4J8Z DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.3 35:6 HardDisk 0_6 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:10:52-05:00 JK11D1YAJ7JXGZ 2000011650924 6 normal JK11D1YAJ7JXGZ DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.3 35:7 HardDisk 0_7 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:10:54-05:00 JK11D1YAJB4E5Z 2000011650924 7 normal JK11D1YAJB4E5Z DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.3 35:8 HardDisk 0_8 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:10:55-05:00 JK11D1YAJ8TY3Z 2000011650924 8 normal JK11D1YAJ8TY3Z DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.3 35:9 HardDisk 0_9 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:10:56-05:00 JK11D1YAJ8TXKZ 2000011650924 9 normal JK11D1YAJ8TXKZ DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.3 FLASH_1_0 FlashDisk Sun Flash Accelerator F20 PCIe Card D20Y 2011-05-06T12:00:49-05:00 1014M02JC3 24575868928 0 "PCI Slot: 1; FDOM: 0" not present 1014M02JC3 DMG_UNKNOWN FALSE TRUE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_1_1 FlashDisk Sun Flash Accelerator F20 PCIe Card D20Y 2011-05-06T12:00:49-05:00 1014M02JYG 24575868928 0 "PCI Slot: 1; FDOM: 1" not present 1014M02JYG DMG_UNKNOWN FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_1_2 FlashDisk Sun Flash Accelerator F20 PCIe Card D20Y 2011-05-06T12:00:49-05:00 1014M02JV9 24575868928 0 "PCI Slot: 1; FDOM: 2" not present 1014M02JV9 DMG_UNKNOWN FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_1_3 FlashDisk Sun Flash Accelerator F20 PCIe Card D20Y 2011-05-06T12:00:49-05:00 1014M02J93 24575868928 0 "PCI Slot: 1; FDOM: 3" not present 1014M02J93 DMG_UNKNOWN FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_2_0 FlashDisk Sun Flash Accelerator F20 PCIe Card D20Y 2011-05-06T12:00:49-05:00 1014M02JFK 24575868928 0 "PCI Slot: 2; FDOM: 0" not present 1014M02JFK DMG_UNKNOWN FALSE TRUE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_2_1 FlashDisk Sun Flash Accelerator F20 PCIe Card D20Y 2011-05-06T12:00:49-05:00 1014M02JFL 24575868928 0 "PCI Slot: 2; FDOM: 1" not present 1014M02JFL DMG_UNKNOWN FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_2_2 FlashDisk Sun Flash Accelerator F20 PCIe Card D20Y 2011-05-06T12:00:49-05:00 1014M02JF7 24575868928 0 "PCI Slot: 2; FDOM: 2" not present 1014M02JF7 DMG_UNKNOWN FALSE TRUE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_2_3 FlashDisk Sun Flash Accelerator F20 PCIe Card D20Y 2011-05-06T12:00:49-05:00 1014M02JF8 24575868928 0 "PCI Slot: 2; FDOM: 3" not present 1014M02JF8 DMG_UNKNOWN FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_4_0 FlashDisk 4_0 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T12:00:49-05:00 1014M02HP5 24575868928 0 "PCI Slot: 4; FDOM: 0" normal 1014M02HP5 DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_4_1 FlashDisk 4_1 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T12:00:49-05:00 1014M02HNN 24575868928 0 "PCI Slot: 4; FDOM: 1" normal 1014M02HNN DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_4_2 FlashDisk 4_2 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T12:00:49-05:00 1014M02HP2 24575868928 0 "PCI Slot: 4; FDOM: 2" normal 1014M02HP2 DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_4_3 FlashDisk 4_3 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T12:00:49-05:00 1014M02HP4 24575868928 0 "PCI Slot: 4; FDOM: 3" normal 1014M02HP4 DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_5_0 FlashDisk 5_0 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T12:00:49-05:00 1014M02JUD 24575868928 0 "PCI Slot: 5; FDOM: 0" normal 1014M02JUD DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_5_1 FlashDisk 5_1 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T12:00:49-05:00 1014M02JVF 24575868928 0 "PCI Slot: 5; FDOM: 1" normal 1014M02JVF DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_5_2 FlashDisk 5_2 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T12:00:49-05:00 1014M02JAP 24575868928 0 "PCI Slot: 5; FDOM: 2" normal 1014M02JAP DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.3 FLASH_5_3 FlashDisk 5_3 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T12:00:49-05:00 1014M02JVH 24575868928 0 "PCI Slot: 5; FDOM: 3" normal 1014M02JVH DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 16:0 HardDisk 0_0 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2013-02-05T10:21:30-06:00 JK1151YAJ27ANZ 2000011650924 0 normal JK1151YAJ27ANZ DMG_SYSTEM_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.4 16:1 HardDisk 0_1 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2013-02-07T10:52:03-06:00 JK11D1B8J9LG8Z 2000011650924 1 normal JK11D1B8J9LG8Z DMG_SYSTEM_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.4 16:10 HardDisk 0_10 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:09:38-05:00 JK1160YAHSJGBT 2000011650924 10 normal JK1160YAHSJGBT DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.4 16:11 HardDisk 0_11 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:09:39-05:00 JK1160YAHNTS9T 2000011650924 11 normal JK1160YAHNTS9T DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.4 16:2 HardDisk 0_2 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:09:28-05:00 JK1160YAHP8NHT 2000011650924 2 normal JK1160YAHP8NHT DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.4 16:3 HardDisk 0_3 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:09:29-05:00 JK1160YAHP0AST 2000011650924 3 normal JK1160YAHP0AST DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.4 16:4 HardDisk 0_4 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:09:30-05:00 JK1160YAHNPEGT 2000011650924 4 normal JK1160YAHNPEGT DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.4 16:5 HardDisk 0_5 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2013-02-07T10:53:26-06:00 JK11D1YAJJAN8Z 2000011650924 5 normal JK11D1YAJJAN8Z DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.4 16:6 HardDisk 0_6 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:09:33-05:00 JK1160YAHP0ULT 2000011650924 6 normal JK1160YAHP0ULT DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.4 16:7 HardDisk 0_7 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:09:34-05:00 JK1160YAHSH6WT 2000011650924 7 normal JK1160YAHSH6WT DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.4 16:8 HardDisk 0_8 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:09:35-05:00 JK1160YAHPB4BT 2000011650924 8 normal JK1160YAHPB4BT DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.4 16:9 HardDisk 0_9 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2010-05-15T21:09:37-05:00 JK1160YAHSJ7PT 2000011650924 9 normal JK1160YAHSJ7PT DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.4 FLASH_1_0 FlashDisk 1_0 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1014M02JWP 24575868928 0 "PCI Slot: 1; FDOM: 0" normal 1014M02JWP DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_1_1 FlashDisk 1_1 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1014M02JWN 24575868928 0 "PCI Slot: 1; FDOM: 1" normal 1014M02JWN DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_1_2 FlashDisk 1_2 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1014M02JWQ 24575868928 0 "PCI Slot: 1; FDOM: 2" normal 1014M02JWQ DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_1_3 FlashDisk 1_3 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1014M02JWA 24575868928 0 "PCI Slot: 1; FDOM: 3" normal 1014M02JWA DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_2_0 FlashDisk 2_0 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1016M02K6T 24575868928 0 "PCI Slot: 2; FDOM: 0" normal 1016M02K6T DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_2_1 FlashDisk 2_1 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1016M02KEE 24575868928 0 "PCI Slot: 2; FDOM: 1" normal 1016M02KEE DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_2_2 FlashDisk 2_2 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1016M02K6U 24575868928 0 "PCI Slot: 2; FDOM: 2" normal 1016M02K6U DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_2_3 FlashDisk 2_3 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1016M02KF0 24575868928 0 "PCI Slot: 2; FDOM: 3" normal 1016M02KF0 DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_4_0 FlashDisk 4_0 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1014M02HK2 24575868928 0 "PCI Slot: 4; FDOM: 0" normal 1014M02HK2 DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_4_1 FlashDisk 4_1 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1014M02HK4 24575868928 0 "PCI Slot: 4; FDOM: 1" normal 1014M02HK4 DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_4_2 FlashDisk 4_2 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1014M02HEM 24575868928 0 "PCI Slot: 4; FDOM: 2" normal 1014M02HEM DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_4_3 FlashDisk 4_3 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1014M02HGU 24575868928 0 "PCI Slot: 4; FDOM: 3" normal 1014M02HGU DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_5_0 FlashDisk 5_0 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 0940M018DG 24575868928 0 "PCI Slot: 5; FDOM: 0" normal 0940M018DG DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_5_1 FlashDisk 5_1 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1014M02JXM 24575868928 0 "PCI Slot: 5; FDOM: 1" normal 1014M02JXM DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_5_2 FlashDisk 5_2 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1014M02JXP 24575868928 0 "PCI Slot: 5; FDOM: 2" normal 1014M02JXP DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.4 FLASH_5_3 FlashDisk 5_3 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-05-06T11:59:44-05:00 1014M02J2E 24575868928 0 "PCI Slot: 5; FDOM: 3" normal 1014M02J2E DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 16:0 HardDisk 0_0 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2013-02-05T12:20:03-06:00 JK11D1YAK4SRWZ 2000011650924 0 normal JK11D1YAK4SRWZ DMG_SYSTEM_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.5 16:1 HardDisk 0_1 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2013-02-07T10:53:25-06:00 JK11D1YAJE122Z 2000011650924 1 normal JK11D1YAJE122Z DMG_SYSTEM_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.5 16:10 HardDisk 0_10 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2011-10-26T12:38:40-05:00 JK11D1YAJB3PRZ 2000011650924 10 normal JK11D1YAJB3PRZ DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.5 16:11 HardDisk 0_11 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2011-10-26T12:38:46-05:00 JK11D1YAJ8THDZ 2000011650924 11 normal JK11D1YAJ8THDZ DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.5 16:2 HardDisk 0_2 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2011-10-26T12:37:58-05:00 JK11D1YAJ8T7YZ 2000011650924 2 normal JK11D1YAJ8T7YZ DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.5 16:3 HardDisk 0_3 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2011-10-26T12:38:03-05:00 JK11D1YAJ8TH7Z 2000011650924 3 normal JK11D1YAJ8TH7Z DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.5 16:4 HardDisk 0_4 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2011-10-26T12:38:09-05:00 JK11D1YAJ7WREZ 2000011650924 4 normal JK11D1YAJ7WREZ DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.5 16:5 HardDisk 0_5 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2011-10-26T12:38:14-05:00 JK1161YAGD96BV 2000011650924 5 normal JK1161YAGD96BV DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.5 16:6 HardDisk 0_6 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2011-10-26T12:38:19-05:00 JK11D1YAJ7WL8Z 2000011650924 6 normal JK11D1YAJ7WL8Z DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.5 16:7 HardDisk 0_7 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2011-10-26T12:38:24-05:00 JK11D1YAJ7WR0Z 2000011650924 7 normal JK11D1YAJ7WR0Z DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.5 16:8 HardDisk 0_8 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2011-10-26T12:38:29-05:00 JK11D1YAJAZKZZ 2000011650924 8 normal JK11D1YAJAZKZZ DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.5 16:9 HardDisk 0_9 "HITACHI H7220AA30SUN2.0T" JKAOA28A 2011-10-26T12:38:35-05:00 JK11D1YAJ8T7TZ 2000011650924 9 normal JK11D1YAJ8T7TZ DMG_DATA_HDD2 FALSE FALSE FALSE FALSE FALSE 0 0 192.168.12.5 FLASH_1_0 FlashDisk 1_0 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02N8T 24575868928 0 "PCI Slot: 1; FDOM: 0" normal 1016M02N8T DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_1_1 FlashDisk 1_1 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02N75 24575868928 0 "PCI Slot: 1; FDOM: 1" normal 1016M02N75 DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_1_2 FlashDisk 1_2 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02N9P 24575868928 0 "PCI Slot: 1; FDOM: 2" normal 1016M02N9P DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_1_3 FlashDisk 1_3 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02N9Q 24575868928 0 "PCI Slot: 1; FDOM: 3" normal 1016M02N9Q DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_2_0 FlashDisk 2_0 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02MNK 24575868928 0 "PCI Slot: 2; FDOM: 0" normal 1016M02MNK DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_2_1 FlashDisk 2_1 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02N0D 24575868928 0 "PCI Slot: 2; FDOM: 1" normal 1016M02N0D DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_2_2 FlashDisk 2_2 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02MWK 24575868928 0 "PCI Slot: 2; FDOM: 2" normal 1016M02MWK DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_2_3 FlashDisk 2_3 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02MYY 24575868928 0 "PCI Slot: 2; FDOM: 3" normal 1016M02MYY DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_4_0 FlashDisk 4_0 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02NJE 24575868928 0 "PCI Slot: 4; FDOM: 0" normal 1016M02NJE DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_4_1 FlashDisk 4_1 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02NJ7 24575868928 0 "PCI Slot: 4; FDOM: 1" normal 1016M02NJ7 DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_4_2 FlashDisk 4_2 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02NJH 24575868928 0 "PCI Slot: 4; FDOM: 2" normal 1016M02NJH DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_4_3 FlashDisk 4_3 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02NGK 24575868928 0 "PCI Slot: 4; FDOM: 3" normal 1016M02NGK DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_5_0 FlashDisk 5_0 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02MWE 24575868928 0 "PCI Slot: 5; FDOM: 0" normal 1016M02MWE DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_5_1 FlashDisk 5_1 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02MWC 24575868928 0 "PCI Slot: 5; FDOM: 1" normal 1016M02MWC DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_5_2 FlashDisk 5_2 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02MTG 24575868928 0 "PCI Slot: 5; FDOM: 2" normal 1016M02MTG DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 192.168.12.5 FLASH_5_3 FlashDisk 5_3 "Sun Flash Accelerator F20 PCIe Card" D21Y 2011-10-26T12:38:46-05:00 1016M02NH2 24575868928 0 "PCI Slot: 5; FDOM: 3" normal 1016M02NH2 DMG_FDD1 FALSE FALSE FALSE FALSE FALSE 0 0 0 0 0 0 84 rows selected.
The output should be more or less self-explanatory for Exadata DBAs.
Notes:
- Bane Radulović (the ASM Support Guy) just recently wrote a blog entry (and MOS note) about identifying poorly performing disks in Exadata
- Vishal Desai has also written some scripts which allow list Exadata cell disks (and other cool stuff too!)
Enjoy!
