Monitor Temporary Tablespace Usage

 Monitor Temporary Tablespace Usage

SELECT (s.tot_used_blocks / f.total_blocks) * 100 AS "percent used"
  FROM (SELECT SUM (used_blocks) tot_used_blocks
          FROM v$sort_segment
         WHERE tablespace_name = 'TEMPTS1') s,
       (SELECT SUM (blocks) total_blocks
          FROM dba_temp_files
         WHERE tablespace_name = 'TEMPTS1') f;