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 NULL 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