select
  /*+ ordered use_nl(fc) */
  fc.inst_id                               -- INST_ID NUMBER
  ts.name,                                 -- TABLESPACE_NAME VARCHAR2(30)
  fc.ktstfctfno,                           -- FILE_ID NUMBER
  fc.ktstfcec,                             -- EXTENTS_CACHED NUMBER
  fc.ktstfceu,                             -- EXTENTS_USED NUMBER
  fc.ktstfcbc,                             -- BLOCKS_CACHED NUMBER
  fc.ktstfcbu,                             -- BLOCKS_USED NUMBER
  fc.ktstfcbc*ts.blocksize,                -- BYTES_CACHED NUMBER
  fc.ktstfcbu*ts.blocksize,                -- BYTES_USED NUMBER
  fc.ktstfcfno                             -- RELATIVE_FNO NUMBER
from
  ts$ ts,
  x$ktstfc fc
where
  ts.contents$ = 1 and ts.bitmapped <> 0 and ts.online$ = 1 and ts.ts# = fc.ktstfctsn