select
  inst_id,                                 -- INST_ID NUMBER
  bsrid,                                   -- RECID NUMBER
  bsstm,                                   -- STAMP NUMBER
  bsbss,                                   -- SET_STAMP NUMBER
  bsbsc,                                   -- SET_COUNT NUMBER
  decode(                                  -- BACKUP_TYPE VARCHAR2(1)
    bitand(bstyp,11),1,'D',2,'I',8,'L'),
  decode(                                  -- CONTROLFILE_INCLUDED VARCHAR2(3)
    bitand(bstyp,4+64),4,'YES',68,'SBY','NO'),
  decode(                                  -- INCREMENTAL_LEVEL NUMBER
    bitand(bstyp,16+8192),16,bslvl,NULL),
  bspct,                                   -- PIECES NUMBER
  to_date(                                 -- START_TIME DATE
    bsbst,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- COMPLETION_TIME DATE
    bitand(bstyp, 4096),4096, to_date(bsbst,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'), to_date(bstsm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian')),
  decode(                                  -- ELAPSED_SECONDS NUMBER
    bitand(bstyp, 4096),4096,0, abs((to_date(bstsm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian')- to_date(bsbst,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'))*86400)),
  bsbsz,                                   -- BLOCK_SIZE NUMBER
  decode(                                  -- INPUT_FILE_SCAN_ONLY VARCHAR2(3)
    bitand(bstyp,128),128,'YES','NO'),
  decode(                                  -- KEEP VARCHAR2(3)
    bitand(bstyp, 1792), 0, 'NO', 'YES'),
  to_date(                                 -- KEEP_UNTIL DATE
    bskpt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- KEEP_OPTIONS VARCHAR2(11)
    bitand(bstyp, 1792), 256, 'LOGS', 512, 'NOLOGS', 1024, 'BACKUP_LOGS', NULL),
  decode(                                  -- MULTI_SECTION VARCHAR2(3)
    bitand(bstyp, 16384), 16384, 'YES', 'NO') 
from
  x$kccbs
where
  bitand(bstyp,32) != 32