This view displays information about every sort segment in a given instance.
The most relevant view fields are as follows:
TABLESPACE_NAME
: The name of the tablespaceCURRENT_USERS
: The active users of the segmentTOTAL_BLOCKS
: The total number of blocks in the segmentUSED_BLOCKS
: The number of blocks in the segment allocated to active sortsFREE_BLOCKS
: The number of blocks in the segment not allocated to any sortMAX_BLOCKS
: The maximum number of blocks ever usedMAX_USED_BLOCKS
: The maximum number of blocks used by all sortsMAX_SORT_BLOCKS
: The maximum number of blocks used by an individual sortEXTENT_SIZE
: The extent sizeTOTAL_EXTENTS
: The total number of extents in the segmentUSED_EXTENTS
: The extents allocated to active sortsFREE_EXTENTS
: The extents not allocated to any sortEXTENT_HITS
: The number of times an unused extent was found in the pool