SELECT
  inst_id,                                 -- INST_ID NUMBER
  KTTEFINFOTSN,                            -- TABLESPACE_ID NUMBER
  KTTEFINFOFNO,                            -- RFNO NUMBER
  KTTEFINFOUSP,                            -- ALLOCATED_SPACE NUMBER
  KTTEFINFOSIZE,                           -- FILE_SIZE NUMBER
  KTTEFINFOMSIZE,                          -- FILE_MAXSIZE NUMBER
  KTTEFINFOSCNB,                           -- CHANGESCN_BASE NUMBER
  KTTEFINFOSCNW,                           -- CHANGESCN_WRAP NUMBER
  KTTEFINFOFLAG                            -- FLAG NUMBER
FROM
  X$KTTEFINFO