4.166 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