select
  inst_id,                                 -- INST_ID NUMBER
  group_kffil,                             -- GROUP_NUMBER NUMBER
  number_kffil,                            -- FILE_NUMBER NUMBER
  compound_kffil,                          -- COMPOUND_INDEX NUMBER
  incarn_kffil,                            -- INCARNATION NUMBER
  blksiz_kffil,                            -- BLOCK_SIZE NUMBER
  blkcnt_kffil,                            -- BLOCKS NUMBER
  filsiz_kffil,                            -- BYTES NUMBER
  filspc_kffil,                            -- SPACE NUMBER
  sftype_kffil,                            -- TYPE VARCHAR2(64)
  decode(                                  -- REDUNDANCY VARCHAR2(6)
    redun_kffil, 17, 'UNPROT', 18, 'MIRROR', 19, 'HIGH', 35, 'PARITY', 36, 'PARITY', 37, 'PARITY', 38, 'PARITY'),
  decode(                                  -- STRIPED VARCHAR2(6)
    ftype_kffil, 26, 'CUSTOM', 27, 'CUSTOM', decode(bitand(fdflg_kffil, 2), 2, 'FINE', 'COARSE') ),
  crdate_kffil,                            -- CREATION_DATE DATE
  mddate_kffil,                            -- MODIFICATION_DATE DATE
  decode(                                  -- REDUNDANCY_LOWERED VARCHAR2(1)
    thinned_kffil, 0, 'U', 4294967295, 'N', 'Y'),
  permissions_kffil,                       -- PERMISSIONS VARCHAR2(16)
  usrent_kffil,                            -- USER_NUMBER NUMBER
  usrinc_kffil,                            -- USER_INCARNATION NUMBER
  grpent_kffil,                            -- USERGROUP_NUMBER NUMBER
  grpinc_kffil,                            -- USERGROUP_INCARNATION NUMBER
  decode(                                  -- PRIMARY_REGION VARCHAR2(4)
    prizn_kffil, 1, 'HOT', 'COLD'),
  decode(                                  -- MIRROR_REGION VARCHAR2(4)
    seczn_kffil, 1, 'HOT', 'COLD'),
  hreads_kffil,                            -- HOT_READS NUMBER
  hwrites_kffil,                           -- HOT_WRITES NUMBER
  hbytesr_kffil,                           -- HOT_BYTES_READ NUMBER
  hbytesw_kffil,                           -- HOT_BYTES_WRITTEN NUMBER
  creads_kffil,                            -- COLD_READS NUMBER
  cwrites_kffil,                           -- COLD_WRITES NUMBER
  cbytesr_kffil,                           -- COLD_BYTES_READ NUMBER
  cbytesw_kffil                            -- COLD_BYTES_WRITTEN NUMBER
from
  x$kffil
where
  incarn_kffil <> 0 and visible_kffil > 0