List Exadata Storage Cell disk summary with cellpd.sql and cellpdx.sql scripts

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:

  1. Bane Radulović (the ASM Support Guy) just recently wrote a blog entry (and MOS note) about identifying poorly performing disks in Exadata
  2. Vishal Desai has also written some scripts which allow list Exadata cell disks (and other cool stuff too!)

Enjoy!

Note that this year’s only Advanced Oracle Troubleshooting class takes place in the end of April/May 2014, so sign up now if you plan to attend this year!

This entry was posted in Exadata, Oracle. Bookmark the permalink.

One Response to List Exadata Storage Cell disk summary with cellpd.sql and cellpdx.sql scripts

  1. Jigar says:

    Thanks for sharing this.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>