V$TEMP_SPACE_HEADER definition in Oracle Database 11.2

V$TEMP_SPACE_HEADER

select
  TABLESPACE_NAME,                         -- TABLESPACE_NAME VARCHAR2(30)
  FILE_ID,                                 -- FILE_ID NUMBER
  BYTES_USED,                              -- BYTES_USED NUMBER
  BLOCKS_USED,                             -- BLOCKS_USED NUMBER
  BYTES_FREE,                              -- BYTES_FREE NUMBER
  BLOCKS_FREE,                             -- BLOCKS_FREE NUMBER
  RELATIVE_FNO                             -- RELATIVE_FNO NUMBER
from
  GV$TEMP_SPACE_HEADER
where
  inst_id = USERENV('Instance')

home | up