V$TEMPFILE

This view displays tempfile information.

Column	Datatype	Description
FILE#	NUMBER	The absolute file number
CREATION_CHANGE#	NUMBER	The creation System Change Number (SCN)
CREATION_TIME	DATE	The creation time
TS#	NUMBER	The tablespace number
RFILE#	NUMBER	The relative file number in tablespace
STATUS	VARCHAR2(7)	The status of the file (OFFLINE|ONLINE)
ENABLED	VARCHAR2(10)	Enabled for read and/or write
BYTES	NUMBER	The size of the file in bytes (from file header)
BLOCKS	NUMBER	The size of the file in blocks (from file header)
CREATE_BYTES	NUMBER	The creation size of the file (in bytes)
BLOCK_SIZE	NUMBER	The block size for the file
NAME	VARCHAR2(513)	The name of the file