|
DBA_SEGMENTS
Storage allocated for all database segmentsColumns ___________________________ OWNER Username of the segment owner 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 HEADER_FILE ID of the file containing the segment header HEADER_BLOCK ID of the block containing the segment header 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 in this segment FREELIST_GROUPS Number of freelist groups allocated in this segment RELATIVE_FNO Relative number of the file containing the segment header BUFFER_POOL The default buffer pool to be used for segments blocks
Related: