V$TEMPFILE

Columns
   ___________________________
 
   BLOCKS
   BYTES
   ENABLED
   RFILE#
   CREATION_TIME
   CREATE_BYTES
   FILE#
   STATUS
   CREATION_CHANGE#
   NAME
   TS#
   BLOCK_SIZE

Related Commands: