Oracle: DBA_TEMP_FILES

dba_temp_files comes also as cdb_temp_files.

Returns a record for each temp file.