DBA_HIST_SEG_STAT_OBJ

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(30)`	`NOT NULL`	Owner of the object
`OBJECT_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the object
`SUBOBJECT_NAME`	`VARCHAR2(30)`		Name of the subobject
`OBJECT_TYPE`	`VARCHAR2(18)`		Type of the object
`TABLESPACE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Tablespace Name for the object
`PARTITION_TYPE`	`VARCHAR2(8)`		Partition Type, if relevant