GV$TEMP_EXTENT_POOL

select
/*+ ordered use_nl (fc) */ 
fc.inst_id,              -- INST_ID NUMBER
ts.name,                 -- TABLESPACE_NAME NOT
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
home |  up  |  mailbox