Knowledge Base : Monitor TEMP usage

SELECT ROUND(SUM( su.blocks * bs.block_size)/1024/1024,3) FROM v$sort_usage su, (SELECT block_size FROM dba_tablespaces WHERE contents = 'TEMPORARY') bs;