-- Determine current status of temp space usage
select CURRENT_USERS, TOTAL_EXTENTS, USED_EXTENTS, FREE_EXTENTS,
ADDED_EXTENTS, EXTENT_HITS, FREED_EXTENTS, FREE_REQUESTS, MAX_SIZE,
MAX_USED_SIZE, MAX_SORT_SIZE
from v$sort_segment;