select
  d.inst_id,                               -- INST_ID NUMBER
  d.grpnum_kfdsk,                          -- GROUP_NUMBER NUMBER
  d.number_kfdsk,                          -- DISK_NUMBER NUMBER
  d.compound_kfdsk,                        -- COMPOUND_INDEX NUMBER
  d.incarn_kfdsk,                          -- INCARNATION NUMBER
  decode(                                  -- MOUNT_STATUS VARCHAR2(7)
    d.mntsts_kfdsk, 1, 'MISSING', 2, 'CLOSED', 3, 'OPENED', 4, 'CACHED', 5, 'IGNORED', 6, 'IGNORED', 7, 'CLOSING', 8, 'IGNORED', 9, 'IGNORED', 'INVALID'),
  decode(                                  -- HEADER_STATUS VARCHAR2(12)
    d.hdrsts_kfdsk, 1, 'UNKNOWN', 2, 'CANDIDATE', 3, 'MEMBER', 4, 'FORMER', 5, 'CONFLICT', 6, 'INCOMPATIBLE', 7, 'PROVISIONED', 8, 'FOREIGN', 'INVALID'),
  decode(                                  -- MODE_STATUS VARCHAR2(7)
    d.grpnum_kfdsk, 0, 'ONLINE', decode(d.mode_kfdsk, 0, 'UNKNOWN', 127, 'ONLINE', 21, 'OFFLINE', 1, 'OFFLINE', 'SYNCING')),
  decode(                                  -- STATE VARCHAR2(8)
    d.state_kfdsk, 1, 'UNKNOWN', 2, 'NORMAL', 3, 'UNUSED', 4, 'DROPPING', 5, decode(d.mode_kfdsk, 127, 'DROPPING', 'FORCING'), 6, 'FORCING', 7, 'DROPPED', 8, 'ADDING', 'INVALID'),
  decode(                                  -- REDUNDANCY VARCHAR2(7)
    d.redun_kfdsk, 16, 'UNPROT', 17, 'UNPROT', 18, 'MIRROR', 19, 'MIRROR', 20, 'MIRROR', 21, 'MIRROR', 22, 'MIRROR', 23, 'MIRROR', 32, 'PARITY', 33, 'PARITY', 34, 'PARITY', 35, 'PARITY', 36, 'PARITY', 37, 'PARITY', 38, 'PARITY', 39, 'PARITY', 'UNKNOWN'),
  d.libnam_kfdsk,                          -- LIBRARY VARCHAR2(64)
  d.osmb_kfdsk,                            -- OS_MB NUMBER
  d.totmb_kfdsk,                           -- TOTAL_MB NUMBER
  d.totmb_kfdsk - d.usedmb_kfdsk,          -- FREE_MB NUMBER
  d.hotmb_kfdsk,                           -- HOT_USED_MB NUMBER
  d.coldmb_kfdsk,                          -- COLD_USED_MB NUMBER
  d.asmname_kfdsk,                         -- NAME VARCHAR2(30)
  d.failname_kfdsk,                        -- FAILGROUP VARCHAR2(30)
  d.label_kfdsk,                           -- LABEL VARCHAR2(31)
  d.path_kfdsk,                            -- PATH VARCHAR2(256)
  d.udid_kfdsk,                            -- UDID VARCHAR2(64)
  d.product_kfdsk,                         -- PRODUCT VARCHAR2(32)
  d.crdate_kfdsk,                          -- CREATE_DATE DATE
  d.mtdate_kfdsk,                          -- MOUNT_DATE DATE
  d.timer_kfdsk,                           -- REPAIR_TIMER NUMBER
  k.read_kfkid,                            -- READS NUMBER
  k.write_kfkid,                           -- WRITES NUMBER
  k.rerr_kfkid,                            -- READ_ERRS NUMBER
  k.werr_kfkid,                            -- WRITE_ERRS NUMBER
  k.rtime_kfkid/1000000,                   -- READ_TIME NUMBER
  k.wtime_kfkid/1000000,                   -- WRITE_TIME NUMBER
  k.bytesr_kfkid,                          -- BYTES_READ NUMBER
  k.bytesw_kfkid,                          -- BYTES_WRITTEN NUMBER
  decode(                                  -- PREFERRED_READ VARCHAR2(1)
    d.prefrd_kfdsk, 0, ' ', 1, 'Y', 2, 'N', 3, 'U'),
  d.asmhashval_kfdsk,                      -- HASH_VALUE NUMBER
  k.hread_kfkid,                           -- HOT_READS NUMBER
  k.hwrite_kfkid,                          -- HOT_WRITES NUMBER
  k.hbytesr_kfkid,                         -- HOT_BYTES_READ NUMBER
  k.hbytesw_kfkid,                         -- HOT_BYTES_WRITTEN NUMBER
  k.cread_kfkid,                           -- COLD_READS NUMBER
  k.cwrite_kfkid,                          -- COLD_WRITES NUMBER
  k.cbytesr_kfkid,                         -- COLD_BYTES_READ NUMBER
  k.cbytesw_kfkid,                         -- COLD_BYTES_WRITTEN NUMBER
  decode(                                  -- VOTING_FILE VARCHAR2(1)
    bitand(d.flags_kfdsk, 512), 512, 'Y', 'N'),
  d.blksz_kfdsk,                           -- SECTOR_SIZE NUMBER
  decode(                                  -- FAILGROUP_TYPE VARCHAR2(7)
    bitand(d.flags_kfdsk, 256), 256, 'QUORUM', 'REGULAR') 
from
  x$kfdsk d,
  x$kfkid k
where
  d.mntsts_kfdsk != 0 and d.kfkid_kfdsk = k.idptr_kfkid(+)