|
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: