USER_SEGMENTS
Storage allocated for all database segmentsColumns
___________________________
TABLESPACE_NAME
Name of the tablespace containing the segment
NEXT_EXTENT
Size, in bytes, of the next extent to be allocated to the segment
FREELIST_GROUPS
Number of freelist groups allocated to this segment
FREELISTS
Number of process freelists allocated to this segment
PCT_INCREASE
Percent by which to increase the size of the next extent to be allocated
MAX_EXTENTS
Maximum number of extents allowed in the segment
MIN_EXTENTS
Minimum number of extents allowed in the segment
BUFFER_POOL
The default buffer pool to be used for blocks from this segment
INITIAL_EXTENT
Size, in bytes, of the initial extent of the segment
EXTENTS
Number of extents allocated to the segment
BYTES
Size, in bytes, of the segment
SEGMENT_TYPE
Type of segment: `TABLE`, `CLUSTER`, `INDEX`, `ROLLBACK`, `DEFERRED ROLLBACK`, `TEMPORARY`, `SPACE HEADER`, or `CACHE`
PARTITION_NAME
Partition/Subpartition Name, if any, of the segment
SEGMENT_NAME
Name, if any, of the segment
BLOCKS
Size, in Oracle blocks, of the segment
Related Commands: