select
  xv.inst_id,                              -- INST_ID NUMBER
  xv.group_kfvol,                          -- GROUP_NUMBER NUMBER
  xv.name_kfvol,                           -- VOLUME_NAME VARCHAR2(30)
  xv.compound_kfvol,                       -- COMPOUND_INDEX NUMBER
  xf.filsiz_kffil/(1024*1024),             -- SIZE_MB NUMBER
  xv.volnum_kfvol,                         -- VOLUME_NUMBER NUMBER
  decode(                                  -- REDUNDANCY VARCHAR2(6)
    xf.redun_kffil, 17, 'UNPROT', 18, 'MIRROR', 19, 'HIGH', 35, 'PARITY', 36, 'PARITY', 37, 'PARITY', 38, 'PARITY'),
  xf.strpwd_kffil,                         -- STRIPE_COLUMNS NUMBER
  POWER(2, xf.strpsz_kffil)/1024,          -- STRIPE_WIDTH_K NUMBER
  xf.number_kffil,                         -- FILE_NUMBER NUMBER
  xf.incarn_kffil,                         -- INCARNATION NUMBER
  xv.drl_filenum_kfvol,                    -- DRL_FILE_NUMBER NUMBER
  xv.usage_kfvol,                          -- USAGE VARCHAR2(30)
  decode(                                  -- STATE VARCHAR2(8)
    xv.state_kfvol, 0, 'DISABLED', 1, 'ENABLED'),
  xv.extent_size_mb_kfvol * xf.strpwd_kffil,-- RESIZE_UNIT_MB NUMBER
  xv.device_kfvol,                         -- VOLUME_DEVICE VARCHAR2(256)
  xv.mountpath_kfvol                       -- MOUNTPATH VARCHAR2(1024)
from
  x$kfvol xv,
  x$kffil xf
where
  xv.group_kfvol = xf.group_kffil and xv.filenum_kfvol <> 0 and xv.filenum_kfvol = xf.number_kffil