select
  inst_id,                                 -- INST_ID NUMBER
  file_idx,                                -- FILE_MAP_IDX NUMBER
  file_cfgid,                              -- FILE_CFGID VARCHAR2(256)
  decode(                                  -- FILE_STATUS VARCHAR2(7)
    file_status,1, 'VALID',2,'INVALID' ),
  file_name,                               -- FILE_NAME VARCHAR2(256)
  decode(                                  -- FILE_TYPE VARCHAR2(11)
    file_type,1,'DATAFILE', 2,'SPFILE',3,'TEMPFILE',4,'CONTROLFILE',5,'LOGFILE',6,'ARCHIVEFILE'),
  decode(                                  -- FILE_STRUCTURE VARCHAR2(9)
    file_struct,1,'FILE',2,'RAWVOLUME',3,'RAWDEVICE',4,'ASMFILE',5,'NONE'),
  file_size,                               -- FILE_SIZE NUMBER
  file_nexts,                              -- FILE_NEXTS NUMBER
  to_number(                               -- LIB_IDX NUMBER
    decode(lib_idx,4294967295,NULL,lib_idx)) 
from
  x$ksfmfile