GV$TEMP_EXTENT_MAP definition in Oracle Database 11.2
GV$TEMP_EXTENT_MAP

select
  /*+ ordered use_nl(me) */
  me.inst_id                               -- INST_ID NUMBER
  ts.name,                                 -- TABLESPACE_NAME VARCHAR2(30)
  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