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;