[Home] [Help]
VIEW: SYS.GV_$TEMP_SPACE_HEADER
Source
View Text - Preformatted
select "INST_ID","TABLESPACE_NAME","FILE_ID","BYTES_USED","BLOCKS_USED","BYTES_FREE","BLOCKS_FREE","RELATIVE_FNO","CON_ID" from gv$temp_space_header
View Text - HTML Formatted
SELECT "INST_ID"
, "TABLESPACE_NAME"
, "FILE_ID"
, "BYTES_USED"
, "BLOCKS_USED"
, "BYTES_FREE"
, "BLOCKS_FREE"
, "RELATIVE_FNO"
, "CON_ID"
FROM GV$TEMP_SPACE_HEADER