Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-12
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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