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;