Oracle教程 2023-02-24

Oracle 视图 DBA_HIST_SEG_STAT_OBJ 官方解释，作用，如何使用详细说明

Oracle视图DBA_HIST_SEG_STAT_OBJ被用来显示任意给定时段内指定segments（表空间、表或索引）的状态统计信息。它由每秒/每分钟/每小时/每天/每周/每月的统计聚集来进行空间管理。它还可以用于比较最近的时间段的不同统计信息，以检查系统的最终执行情况。

要使用Oracle视图DBA_HIST_SEG_STAT_OBJ，首先必须运行数据保留配置脚本DBMS_WORKLOAD_REPOSITORY.create_snapshot_settings，以确保数据被收集。然后，可以使用如下查询语句检索给定时期内指定segments的信息：

SELECT * FROM DBA_HIST_SEG_STAT_OBJ WHERE segment_id = ‘&discontinued_seg_id’
AND snap_id BETWEEN &snap_id1 AND &snap_id2;

其中，discontinued_seg_id是需要查询的segment ID，snap_id1是起始时期内最后一个快照的编号，snap_id2是结束时期内最后一个快照的编号。

DBA_HIST_SEG_STAT_OBJ displays all the names of the segments captured in the workload repository.

This view is used with the DBA_HIST_SEG_STAT view.

Column	Datatype	NULL	Description
`DBID`	`NUMBER`	`NOT NULL`	Database ID
`TS#`	`NUMBER`	`NOT NULL`	Tablespace number
`OBJ#`	`NUMBER`	`NOT NULL`	Dictionary object number
`DATAOBJ#`	`NUMBER`	`NOT NULL`	Data object number
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the object
`OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the object
`SUBOBJECT_NAME`	`VARCHAR2(128)`		Name of the subobject (for example: partition)
`OBJECT_TYPE`	`VARCHAR2(18)`		Type of the object for example: table, tablespace)
`TABLESPACE_NAME`	`VARCHAR2(30)`		Tablespace Name for the object
`PARTITION_TYPE`	`VARCHAR2(8)`		Partition Type, if relevant
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data