home - keyword index

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

home - keyword index

Comment on this page: