DBA Data[Home] [Help]

VIEW: SYS.GV_$TEMP_EXTENT_MAP

Source

View Text - Preformatted

select "INST_ID","TABLESPACE_NAME","FILE_ID","BLOCK_ID","BYTES","BLOCKS","OWNER","RELATIVE_FNO","CON_ID" from gv$temp_extent_map
View Text - HTML Formatted

SELECT "INST_ID"
, "TABLESPACE_NAME"
, "FILE_ID"
, "BLOCK_ID"
, "BYTES"
, "BLOCKS"
, "OWNER"
, "RELATIVE_FNO"
, "CON_ID"
FROM GV$TEMP_EXTENT_MAP