How To: Fix Flash disk poor performance status

In my last company, we support a lot of Exadata. unlike with other company the DBA’s job is only limited to DB Node. but with my previous company we DBA’s support everything.. as in everything, since we have access to root of both DB and Storage Cell.

Sometimes flashdisk poor performance.. but something you can fix it without replacing it. but if it keeps coming you may need to replace it.

1. Verify its status

 
CellCLI> list flashcache detail;
         name:                   edwpcel08_FLASHCACHE
         cellDisk:               FD_15_edwpcel08,FD_10_edwpcel08,FD_12_edwpcel08,FD_02_edwpcel08,FD_09_edwpcel08,FD_00_edwpcel08,FD_08_edwpcel08,FD_11_edwpcel08,FD_13_edwpcel08,FD_01_edwpcel08,FD_07_edwpcel08,FD_03_edwpcel08,FD_06_edwpcel08,FD_04_edwpcel08,FD_05_edwpcel08
         creationTime:           2012-05-22T18:51:56+00:00
         degradedCelldisks:      FD_14_edwpcel08
         effectiveCacheSize:     341.953125G
         id:                     e262a045-517f-4925-a74d-06f67bcceaae
         size:                   364.75G
         status:                 warning - degraded

2. Check the flash disk that is having issue.

 
CellCLI> LIST PHYSICALDISK WHERE DISKTYPE=flashdisk AND STATUS= 'warning - poor performance' DETAIL
         name:                   FLASH_4_2
         diskType:               FlashDisk
         luns:                   4_2
         makeModel:              "Sun Flash Accelerator F20 PCIe Card"
         physicalFirmware:       D21Y
         physicalInsertTime:     2014-07-29T14:47:06+00:00
         physicalSerial:         1050M055PA
         physicalSize:           22.8880615234375G
         slotNumber:             "PCI Slot: 4; FDOM: 2"
         status:                 warning - poor performance

CellCLI>
 
CellCLI> list physicaldisk FLASH_4_2 detail;
         name:                   FLASH_4_2
         diskType:               FlashDisk
         luns:                   4_2
         makeModel:              "Sun Flash Accelerator F20 PCIe Card"
         physicalFirmware:       D21Y
         physicalInsertTime:     2014-07-29T14:47:06+00:00
         physicalSerial:         1050M055PA
         physicalSize:           22.8880615234375G
         slotNumber:             "PCI Slot: 4; FDOM: 2"
         status:                 warning - poor performance

CellCLI

3. Now let’s try to fix it.

 
CellCLI> alter lun 4_2 reenable force;
LUN 4_2 on physical disk FLASH_4_2 successfully marked to status normal.LUN 4_2 successfully reenabled.

CellCLI>

4. Now check it again..

 
CellCLI> list physicaldisk FLASH_4_2 detail;
         name:                   FLASH_4_2
         diskType:               FlashDisk
         luns:                   4_2
         makeModel:              "Sun Flash Accelerator F20 PCIe Card"
         physicalFirmware:       D21Y
         physicalInsertTime:     2014-07-29T14:47:06+00:00
         physicalSerial:         1050M055PA
         physicalSize:           22.8880615234375G
         slotNumber:             "PCI Slot: 4; FDOM: 2"
         status:                 normal 

engage Oracle if it’s coming..

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s