GV$SORT_SEGMENT definition in Oracle Database 11.2
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