select
  inst_id,                                 -- INST_ID NUMBER
  alrid,                                   -- RECID NUMBER
  alstm,                                   -- STAMP NUMBER
  alnam,                                   -- NAME VARCHAR2(513)
  aldst,                                   -- DEST_ID NUMBER
  althp,                                   -- THREAD# NUMBER
  alseq,                                   -- SEQUENCE# NUMBER
  to_number(alrls),                        -- RESETLOGS_CHANGE# NUMBER
  to_date(                                 -- RESETLOGS_TIME DATE
    alrlc,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(alxlc),                        -- RESETLOGS_ID NUMBER
  to_number(allos),                        -- FIRST_CHANGE# NUMBER
  to_date(                                 -- FIRST_TIME DATE
    allot,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(alnxs),                        -- NEXT_CHANGE# NUMBER
  to_date(                                 -- NEXT_TIME DATE
    alnxt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  albct,                                   -- BLOCKS NUMBER
  albsz,                                   -- BLOCK_SIZE NUMBER
  decode(                                  -- CREATOR VARCHAR2(7)
    bitand(alflg, 16+32+64+128+256), 16, 'ARCH', 32, 'FGRD', 64, 'RMAN', 128,'SRMN', 256,'LGWR', 'UNKNOWN'),
  decode(                                  -- REGISTRAR VARCHAR2(7)
    bitand(alflg, 4), 4, 'RFS', decode(bitand(alflg, 16+32+64+128+256), 16, 'ARCH', 32, 'FGRD', 64, 'RMAN', 128,'SRMN', 256,'LGWR', 'UNKNOWN')),
  decode(                                  -- STANDBY_DEST VARCHAR2(3)
    bitand(alflg, 8),0,'NO','YES'),
  decode(                                  -- ARCHIVED VARCHAR2(3)
    bitand(alflg, 2),0,'NO','YES'),
  decode(                                  -- APPLIED VARCHAR2(9)
    bitand(alflg, 1024),0, (decode(bitand(alfl2, 16384),0,'NO','IN-MEMORY')),'YES'),
  decode(                                  -- DELETED VARCHAR2(3)
    bitand(alflg, 1),0,'NO','YES'),
  decode(                                  -- STATUS VARCHAR2(1)
    bitand(alflg, 1+2048+4096), 0, 'A', 1, 'D', 2048,'X', 4096,'U', '?'),
  to_date(                                 -- COMPLETION_TIME DATE
    altsm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- DICTIONARY_BEGIN VARCHAR2(3)
    bitand(alflg,8192),0,'NO','YES'),
  decode(                                  -- DICTIONARY_END VARCHAR2(3)
    bitand(alflg,16384),0,'NO','YES'),
  decode(                                  -- END_OF_REDO VARCHAR2(3)
    bitand(alflg,32768),0,'NO','YES'),
  to_number(bitand(alfl2,15)),             -- BACKUP_COUNT NUMBER
  altoa,                                   -- ARCHIVAL_THREAD# NUMBER
  alacd,                                   -- ACTIVATION# NUMBER
  decode(                                  -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
    bitand(alfl2,64),0,'NO','YES'),
  decode(                                  -- COMPRESSED VARCHAR2(3)
    bitand(alfl2,128),0,'NO','YES'),
  decode(                                  -- FAL VARCHAR2(3)
    bitand(alflg,512),0,'NO','YES'),
  decode(                                  -- END_OF_REDO_TYPE VARCHAR2(10)
    bitand(alfl2,256+512+1024), 256, 'TERMINAL', 512, 'ACTIVATION', 1024, 'RESETLOGS', decode(bitand(alflg,32768),0,'','SWITCHOVER')),
  decode(                                  -- BACKED_BY_VSS VARCHAR2(3)
    bitand(alfl2,4096), 0, 'NO', 'YES') 
from
  x$kccal