V$SORT_SEGMENT

V$SORT_SEGMENT displays information about every sort segment in a given instance. The view is only updated when the tablespace is of the TEMPORARY type.

Column	Datatype	Description
`TABLESPACE_NAME`	`VARCHAR2(31)`	Name of the tablespace
`SEGMENT_FILE`	`NUMBER`	File number of the first extent
`SEGMENT_BLOCK`	`NUMBER`	Block number of the first extent
`EXTENT_SIZE`	`NUMBER`	Extent size
`CURRENT_USERS`	`NUMBER`	Number of active users of the segment
`TOTAL_EXTENTS`	`NUMBER`	Total number of extents in the segment
`TOTAL_BLOCKS`	`NUMBER`	Total number of blocks in the segment
`USED_EXTENTS`	`NUMBER`	Extents allocated to active sorts
`USED_BLOCKS`	`NUMBER`	Blocks allocated to active sorts
`FREE_EXTENTS`	`NUMBER`	Extents not allocated to any sort
`FREE_BLOCKS`	`NUMBER`	Blocks not allocated to any sort
`ADDED_EXTENTS`	`NUMBER`	Number of extent allocations
`EXTENT_HITS`	`NUMBER`	Number of times an unused extent was found in the pool
`FREED_EXTENTS`	`NUMBER`	Number of deallocated extents
`FREE_REQUESTS`	`NUMBER`	Number of requests to deallocate
`MAX_SIZE`	`NUMBER`	Maximum number of extents ever used
`MAX_BLOCKS`	`NUMBER`	Maximum number of blocks ever used
`MAX_USED_SIZE`	`NUMBER`	Maximum number of extents used by all sorts
`MAX_USED_BLOCKS`	`NUMBER`	Maximum number of blocks used by all sorts
`MAX_SORT_SIZE`	`NUMBER`	Maximum number of extents used by an individual sort
`MAX_SORT_BLOCKS`	`NUMBER`	Maximum number of blocks used by an individual sort
`RELATIVE_FNO`	`NUMBER`	Relative file number of the sort segment header