select
  inst_id,                                 -- INST_ID NUMBER
  hxfil,                                   -- FILE# NUMBER
  decode(                                  -- STATUS VARCHAR2(7)
    hxons, 0, 'OFFLINE', 'ONLINE'),
  decode(                                  -- ERROR VARCHAR2(18)
    hxerr, 0, NULL, 1,'FILE MISSING',2,'OFFLINE NORMAL', 3,'NOT VERIFIED', 4,'FILE NOT FOUND',5,'CANNOT OPEN FILE', 6,'CANNOT READ HEADER', 7,'CORRUPT HEADER',8,'WRONG FILE TYPE', 9,'WRONG DATABASE', 10,'WRONG FILE NUMBER',11,'WRONG FILE CREATE', 12,'WRONG FILE CREATE', 16,'DELAYED OPEN',14, 'WRONG RESETLOGS', 15,'OLD CONTROLFILE', 'UNKNOWN ERROR'),
  hxver,                                   -- FORMAT NUMBER
  decode(                                  -- RECOVER VARCHAR2(3)
    hxnrcv, 0,'NO', 1,'YES', NULL),
  decode(                                  -- FUZZY VARCHAR2(3)
    hxifz, 0,'NO', 1,'YES', NULL),
  to_number(fhcrs),                        -- CREATION_CHANGE# NUMBER
  to_date(                                 -- CREATION_TIME DATE
    fhcrt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  fhtnm,                                   -- TABLESPACE_NAME VARCHAR2(30)
  fhtsn,                                   -- TS# NUMBER
  fhrfn,                                   -- RFILE# NUMBER
  to_number(fhrls),                        -- RESETLOGS_CHANGE# NUMBER
  to_date(                                 -- RESETLOGS_TIME DATE
    fhrlc,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(fhscn),                        -- CHECKPOINT_CHANGE# NUMBER
  to_date(                                 -- CHECKPOINT_TIME DATE
    fhtim,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  fhcpc,                                   -- CHECKPOINT_COUNT NUMBER
  fhfsz*fhbsz,                             -- BYTES NUMBER
  fhfsz,                                   -- BLOCKS NUMBER
  hxfnm,                                   -- NAME VARCHAR2(513)
  decode(                                  -- SPACE_HEADER VARCHAR2(40)
    hxlmdba, 0, NULL, hxlmdba),
  decode(                                  -- LAST_DEALLOC_CHANGE# VARCHAR2(16)
    hxlmld_scn, to_number('0'), NULL, hxlmld_scn),
  decode(                                  -- UNDO_OPT_CURRENT_CHANGE# VARCHAR2(40)
    hxuopc_scn, 0, NULL, hxuopc_scn) 
from
  x$kcvfh