V$TEMPFILE
This view displays temporary file information.
Fields
The most relevant view fields are as follows:
FILE#
: The file identifier numberNAME
: The filenameSTATUS
: The file status; it can beONLINE
orOFFLINE
ENABLED
: This is enabled for read and/or writeBYTES
: The size of the file in bytesBLOCKS
: The size of the file in blocksBLOCK_SIZE
: The block size for the file