GV$SORT_SEGMENT

select
inst_id,                 -- INST_ID NUMBER
tablespace_name,         -- TABLESPACE_NAME VARCHAR2(31)
segment_file,            -- SEGMENT_FILE NUMBER
segment_block,           -- SEGMENT_BLOCK NUMBER
extent_size,             -- EXTENT_SIZE NUMBER
current_users,           -- CURRENT_USERS NUMBER
total_extents,           -- TOTAL_EXTENTS NUMBER
total_blocks,            -- TOTAL_BLOCKS NUMBER
used_extents,            -- USED_EXTENTS NUMBER
used_blocks,             -- USED_BLOCKS NUMBER
free_extents,            -- FREE_EXTENTS NUMBER
free_blocks,             -- FREE_BLOCKS NUMBER
added_extents,           -- ADDED_EXTENTS NUMBER
extent_hits,             -- EXTENT_HITS NUMBER
freed_extents,           -- FREED_EXTENTS NUMBER
free_requests,           -- FREE_REQUESTS NUMBER
max_size,                -- MAX_SIZE NUMBER
max_blocks,              -- MAX_BLOCKS NUMBER
max_used_size,           -- MAX_USED_SIZE NUMBER
max_used_blocks,         -- MAX_USED_BLOCKS NUMBER
max_sort_size,           -- MAX_SORT_SIZE NUMBER
max_sort_blocks,         -- MAX_SORT_BLOCKS NUMBER
relative_fno             -- RELATIVE_FNO NUMBER
from
x$ktstssd
home |  up  |  mailbox