select
  TABLESPACE_NAME,                         -- TABLESPACE_NAME VARCHAR2(30)
  FILE_ID,                                 -- FILE_ID NUMBER
  BLOCK_ID,                                -- BLOCK_ID NUMBER
  BYTES,                                   -- BYTES NUMBER
  BLOCKS,                                  -- BLOCKS NUMBER
  OWNER,                                   -- OWNER NUMBER
  RELATIVE_FNO                             -- RELATIVE_FNO NUMBER
from
  GV$TEMP_EXTENT_MAP
where
  inst_id = USERENV('Instance')