• ORACLE-BASE - Temporary Tablespace Enhancements in Oracle Database 11g Release 1
  Temporary Tablespace Enhancements in Oracle Database 11g Release 1
  in Oracle > DB 11g with 11g alter database dba_temp_free_space keep oracle shrink tablespace temp tempfile temporary

dba_temp_free_space from all users