Search notes:

Oracle: V$SORT_SEGMENT

select
   sts.tablespace_name,   
   sts.extent_size,
   sts.total_blocks , sts.used_blocks    , sts.free_blocks,
   sts.total_extents, sts.used_extents   , sts.free_extents,
   sts.max_size     , sts.max_sort_size  , sts.max_used_size,
   sts.max_blocks   , sts.max_sort_blocks, sts.max_used_blocks,
   sts.added_extents,
   sts.current_users,
   sts.extent_hits,
   sts.free_requests,
   sts.freed_extents,
   sts.is_local_temp,
   sts.segment_block,
   sts.segment_file,
   sts.ts#,   
   sts.relative_fno,
   sts.con_id
from
   sys.v$sort_segment sts;

See also

v$sort_usage
Oracle Dynamic Performance Views

Index