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 |