DBA_SEGMENTS

最新推荐文章于 2023-10-26 16:25:26 发布

丹心明月

最新推荐文章于 2023-10-26 16:25:26 发布

阅读量3k

点赞数

分类专栏： Oracle系统视图表文章标签：系统视图

Oracle系统视图表专栏收录该内容

7 篇文章 0 订阅

订阅专栏

DBA_SEGMENTS

DBA_SEGMENTS describes the storage allocated for all segments in the database.--DBA_SEGMENTS描述了在数据库中分配给所有段的存储空间。

Related View --相关视图

USER_SEGMENTS describes the storage allocated for the segments owned by the current user's objects. --USER_SEGMENTS描述了当前对象所拥有的分配给所有段的存储空间。

This view does not display the OWNER, HEADER_FILE, HEADER_BLOCK, or RELATIVE_FNO columns.--该视图不展示所有者，头文件，头块或者相对文件号的列。

Column	Datatype	Description
`OWNER`	`VARCHAR2(30)`	Username of the segment owner --段所有者的名字
`SEGMENT_NAME`	`VARCHAR2(81)`	Name, if any, of the segment --段名
`PARTITION_NAME`	`VARCHAR2(30)`	Object Partition Name (Set to `NULL` for non-partitioned objects)--分区对象的名称（没有分区的设为null）
`SEGMENT_TYPE`	`VARCHAR2(18)`	Type of segment: `INDEX PARTITION, TABLE PARTITION, TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, CACHE, LOBSEGMENT` and `LOBINDEX--段的类型：分区索引，分区表，表，簇，索引，回滚段，延迟回滚？，临时段，缓存段，大字节段？大字节索引？`
`TABLESPACE_NAME`	`VARCHAR2(30)`	Name of the tablespace containing the segment --包含该段的表空间
`HEADER_FILE`	`NUMBER`	ID of the file containing the segment header--包含段头的文件ID
`HEADER_BLOCK`	`NUMBER`	ID of the block containing the segment header--包含段头的块ID
`BYTES`	`NUMBER`	Size, in bytes, of the segment --段的大小（单位byte）
`BLOCKS`	`NUMBER`	Size, in Oracle blocks, of the segment --在Oracle块中段的大小
`EXTENTS`	`NUMBER`	Number of extents allocated to the segment --分配给段的区的数量
`INITIAL_EXTENT`	`NUMBER`	Size in bytes requested for the initial extent of the segment at create time. (Oracle rounds the extent size to multiples of 5 blocks if the requested size is greater than 5 blocks.)--段创建时所需要的初始区大小
`NEXT_EXTENT`	`NUMBER`	Size in bytes of the next extent to be allocated to the segment--分配给段的下个区的大小
`MIN_EXTENTS`	`NUMBER`	Minimum number of extents allowed in the segment--段中允许的最小数量的区
`MAX_EXTENTS`	`NUMBER`	Maximum number of extents allowed in the segment--段中允许的最大数量的区
`PCT_INCREASE`	`NUMBER`	Percent by which to increase the size of the next extent to be allocated--分配的下个区增长的比例
`FREELISTS`	`NUMBER`	Number of process freelists allocated to this segment--分配给段的进程空闲列表的数量
`FREELIST_GROUPS`	`NUMBER`	Number of freelist groups allocated to this segment--分配给段的空闲列表组的数量
`RELATIVE_FNO`	`NUMBER`	Relative file number of the segment header--段头的相对文件号
`BUFFER_POOL`	`VARCHAR2(7)`	Default buffer pool for the object --对象默认的缓冲池