GV$TEMP_SPACE_HEADER
select /*+ ordered use_nl (hc) */ hc.inst_id, -- INST_ID NUMBER ts.name, -- TABLESPACE_NAME NOT hc.ktfthctfno, -- FILE_ID NUMBER (hc.ktfthcsz -- BYTES_USED NUMBER - hc.ktfthcfree) *ts.blocksize, (hc.ktfthcsz -- BLOCKS_USED NUMBER - hc.ktfthcfree), hc.ktfthcfree*ts.blocksize, -- BYTES_FREE NUMBER hc.ktfthcfree, -- BLOCKS_FREE NUMBER hc.ktfthcfno -- RELATIVE_FNO NUMBER from ts$ ts, x$ktfthc hc where ts.contents$ = 1 and ts.bitmapped <> 0 and ts.online$ = 1 and ts.ts# = hc.ktfthctsn and hc.ktfthccval = 0

home |  up  |  mailbox