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 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(128)

 

Owner of the segment

SEGMENT_NAME

VARCHAR2(128)

 

Name of the segment

SEGMENT_TYPE

VARCHAR2(18)

 

The type of segment (TABLE, INDEX, and so on)

PARTITION_NAME

VARCHAR2(128)

 

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