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