select
  /*+ ordered use_nl(hc) */
  hc.inst_id                               -- INST_ID NUMBER
  ts.name,                                 -- TABLESPACE_NAME VARCHAR2(30)
  hc.ktfthctfno,                           -- FILE_ID NUMBER
  (hc.ktfthcsz - hc.ktfthcfree)*ts.blocksize,-- BYTES_USED NUMBER
  (hc.ktfthcsz - hc.ktfthcfree),           -- BLOCKS_USED NUMBER
  hc.ktfthcfree*ts.blocksize,              -- BYTES_FREE NUMBER
  hc.ktfthcfree,                           -- BLOCKS_FREE NUMBER
  hc.ktfthcfno                             -- RELATIVE_FNO NUMBER
from
  ts$ ts,
  x$ktfthc hc
where
  ts.contents$ = 1 and ts.bitmapped <> 0 and ts.online$ = 1 and ts.ts# = hc.ktfthctsn and hc.ktfthccval = 0