DBA_AUTO_SEGADV_CTL

DBA_AUTO_SEGADV_CTL exposes the control information used by the segment advisor. This information gives the DBA an idea of what is happening in the auto advisor.

Column	Datatype	Description
`AUTO_TASKID`	`NUMBER`	Unique task ID generated by the auto advisor
`TABLESPACE_NAME`	`VARCHAR2(30)`	Name of the tablespace containing the segment
`SEGMENT_OWNER`	`VARCHAR2(30)`	Owner of the segment
`SEGMENT_NAME`	`VARCHAR2(81)`	Name of the segment
`SEGMENT_TYPE`	`VARCHAR2(18)`	The type of segment (TABLE, INDEX, and so on)
`PARTITION_NAME`	`VARCHAR2(30)`	Name of the subsegment (if partitioned)
`STATUS`	`VARCHAR2(40)`	Status of the analysis: NEW - the segment/tablespace has not been analyzed BEING-PROCESSED - the segment/tablespace is being processed COMPLETE - the segment/tablespace has been analyzed ERROR - problem with the segment/tablespace
`REASON`	`VARCHAR2(40)`	Reason why this segment was chosen
`REASON_VALUE`	`NUMBER`	A value associated with the reason
`CREATION_TIME`	`TIMESTAMP(6)`	Time when this entry was created
`PROCESSED_TASKID`	`NUMBER`	Auto advisor task that was used to process the segment/tablespace
`END_TIME`	`TIMESTAMP(6)`	Time at which the advisor task was completed