GV$TEMP_EXTENT_MAP

select
/*+ ordered use_nl (me) */ 
me.inst_id,              -- INST_ID NUMBER
ts.name,                 -- TABLESPACE_NAME NOT
me.ktftmetfno,           -- FILE_ID NUMBER
me.ktftmebno,            -- BLOCK_ID NUMBER
me.ktftmeblks*ts.blocksize, -- BYTES NUMBER
me.ktftmeblks,           -- BLOCKS NUMBER
me.ktftmeinst,           -- OWNER NUMBER
me.ktftmefno             -- RELATIVE_FNO NUMBER
from
ts$ ts,
x$ktftme me 
where
ts.contents$ = 1 and ts.bitmapped <> 0 and ts.online$ = 1 and ts.ts# = me.ktftmetsn
home |  up  |  mailbox