GV$TEMP_SPACE_HEADER

select
/*+ ordered use_nl (hc) */ 
hc.inst_id,              -- INST_ID NUMBER
ts.name,                 -- TABLESPACE_NAME VARCHAR2(30)
hc.ktfthctfno,           -- FILE_ID NUMBER
(hc.ktfthcsz             -- BYTES_USED NUMBER
  - hc.ktfthcfree) *ts.blocksize,
(hc.ktfthcsz             -- BLOCKS_USED NUMBER
  - hc.ktfthcfree),
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
home |  up  |  mailbox