select
  TS#,                                     -- TS# NUMBER
  NAME,                                    -- NAME VARCHAR2(30)
  INCLUDED_IN_DATABASE_BACKUP,             -- INCLUDED_IN_DATABASE_BACKUP VARCHAR2(3)
  BIGFILE,                                 -- BIGFILE VARCHAR2(3)
  FLASHBACK_ON,                            -- FLASHBACK_ON VARCHAR2(3)
  ENCRYPT_IN_BACKUP                        -- ENCRYPT_IN_BACKUP VARCHAR2(3)
from
  GV$TABLESPACE
where
  inst_id = USERENV('Instance')