GV$TABLESPACE definition in Oracle Database 10.2 / www.oracledba.ru
GV$TABLESPACE
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