select
  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
  GV$SORT_SEGMENT
where
  inst_id = USERENV('Instance')