select
  inst_id,                                 -- INST_ID NUMBER
  tstsn,                                   -- TS# NUMBER
  tsnam,                                   -- NAME VARCHAR2(30)
  decode(                                  -- INCLUDED_IN_DATABASE_BACKUP VARCHAR2(3)
    bitand(tsflg, 1+2), 1, 'NO', 2,'NO','YES'),
  decode(                                  -- BIGFILE VARCHAR2(3)
    bitand(tsflg, 4), 4,'YES','NO'),
  decode(                                  -- FLASHBACK_ON VARCHAR2(3)
    bitand(tsflg, 8), 8,'NO','YES'),
  decode(                                  -- ENCRYPT_IN_BACKUP VARCHAR2(3)
    bitand(tsflg, 16+32), 16, 'ON', 32, 'OFF', to_char(null)) 
from
  x$kccts
where
  tstsn != -1