How to increase size of temp tablespace in Oracle 12C RAC with ASM?
I've created a new temp file using command:
ALTER TABLESPACE temp
   ADD TEMPFILE '+DATA/ORCL/DATAFILE/temp02.dbf' SIZE 2048M REUSE;

After that SELECT * FROM dba_temp_free_space; command showed me much more space available. However I don't know where old temp file is located and what is its name.
I've found old tempfile name and resized it:
SQL&gt; SELECT * FROM dba_temp_files;

SQL&gt; ALTER DATABASE TEMPFILE '+DATA/ORCL/TEMPFILE/temp.XYZ.XXXXXXXXX' RESIZE 500M;