DBA Data[Home] [Help]

VIEW: SYS.GV_$TEMPFILE

Source

View Text - Preformatted

select "INST_ID","FILE#","CREATION_CHANGE#","CREATION_TIME","TS#","RFILE#","STATUS","ENABLED","BYTES","BLOCKS","CREATE_BYTES","BLOCK_SIZE","NAME","CON_ID" from gv$tempfile
View Text - HTML Formatted

SELECT "INST_ID"
, "FILE#"
, "CREATION_CHANGE#"
, "CREATION_TIME"
, "TS#"
, "RFILE#"
, "STATUS"
, "ENABLED"
, "BYTES"
, "BLOCKS"
, "CREATE_BYTES"
, "BLOCK_SIZE"
, "NAME"
, "CON_ID"
FROM GV$TEMPFILE