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