select
  inst_id,                                 -- INST_ID NUMBER
  bprid,                                   -- RECID NUMBER
  bpstm,                                   -- STAMP NUMBER
  bpbss,                                   -- SET_STAMP NUMBER
  bpbsc,                                   -- SET_COUNT NUMBER
  bpnum,                                   -- PIECE# NUMBER
  bitand(                                  -- COPY# NUMBER
    bpflg, 12)/4 + (bitand(bpext, 64-1) * 4) + 1,
  bpdev,                                   -- DEVICE_TYPE VARCHAR2(17)
  bphdl,                                   -- HANDLE VARCHAR2(513)
  bpcmt,                                   -- COMMENTS VARCHAR2(64)
  bpmdh,                                   -- MEDIA VARCHAR2(65)
  bitand(bpflg, 4080) / 16,                -- MEDIA_POOL NUMBER
  decode(                                  -- CONCUR VARCHAR2(3)
    bitand(bpflg,2),1,'YES','NO'),
  bptag,                                   -- TAG VARCHAR2(32)
  decode(                                  -- STATUS VARCHAR2(1)
    bitand(bpflg, 1+4096+8192),0,'A',1,'D',4096,'X',8192,'U','?'),
  decode(                                  -- DELETED VARCHAR2(3)
    bitand(bpflg,1),1,'YES','NO'),
  to_date(                                 -- START_TIME DATE
    bptsm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_date(                                 -- COMPLETION_TIME DATE
    bptim,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  abs((to_date(bptim,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian')- to_date(bptsm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'))*86400),-- ELAPSED_SECONDS NUMBER
  ((floor(bpext/512) * 4294967296) + bpsz1) * 512,-- BYTES NUMBER
  decode(                                  -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
    bitand(bpflg, 16384),0,'NO','YES'),
  bprsi,                                   -- RMAN_STATUS_RECID NUMBER
  bprst,                                   -- RMAN_STATUS_STAMP NUMBER
  decode(                                  -- COMPRESSED VARCHAR2(3)
    bitand(bpext, 64),64,'YES','NO'),
  decode(                                  -- BACKED_BY_VSS VARCHAR2(3)
    bitand(bpflg, 16384),0,'NO',decode(bitand(bpext, 256),0,'NO','YES')),
  decode(                                  -- ENCRYPTED VARCHAR2(3)
    bitand(bpext, 128),128,'YES','NO'),
  decode(                                  -- BACKED_BY_OSB VARCHAR2(3)
    bitand(bpflg, 16384),16384,'NO',decode(bitand(bpext,256),0,'NO','YES')) 
from
  x$kccbp