GV$TABLESPACE

select
inst_id,                 -- INST_ID NUMBER
tstsn,                   -- TS# NUMBER
tsnam,                   -- NAME VARCHAR2(30)
decode                   -- INCLUDED_IN_DATABASE_BACKUP VARCHAR2(3)
  (bitand (tsflg, 2), 2, 'NO', 'YES'),
decode                   -- BIGFILE VARCHAR2(3)
  (bitand (tsflg, 4), 4, 'YES', 'NO'),
decode                   -- FLASHBACK_ON VARCHAR2(3)
  (bitand (tsflg, 8), 8, 'NO', 'YES') 
from
x$kccts 
where
tstsn != -1
home |  up  |  mailbox