select
  inst_id,                                 -- INST_ID NUMBER
  group_kftmta,                            -- GROUP_NUMBER NUMBER
  entry_kftmta,                            -- ENTRY_NUMBER NUMBER
  decode(                                  -- REDUNDANCY VARCHAR2(6)
    redundancy_kftmta, 17, 'UNPROT', 18, 'MIRROR', 19, 'HIGH', 35, 'PARITY', 36, 'PARITY', 37, 'PARITY', 38, 'PARITY'),
  decode(                                  -- STRIPE VARCHAR2(6)
    bitand(flags_kftmta, 1), 1, 'FINE', 'COARSE'),
  decode(                                  -- SYSTEM VARCHAR2(1)
    bitand(flags_kftmta, 4), 4, 'Y', 'N'),
  name_kftmta,                             -- NAME VARCHAR2(30)
  decode(                                  -- PRIMARY_REGION VARCHAR2(4)
    prizn_kftmta, 1, 'HOT', 'COLD'),
  decode(                                  -- MIRROR_REGION VARCHAR2(4)
    seczn_kftmta, 1, 'HOT', 'COLD') 
from
  x$kftmta