Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
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
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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