|
TABLESPACE_NAME
|
VARCHAR2(31)
|
Name of 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
|
|
RELATIVE_FNO
|
NUMBER
|
Relative file number of the sort segment header
|
|
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
|
