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