DBA_AUTO_SEGADV_SUMMARY

DBA_AUTO_SEGADV_SUMMARY provides a summary of the auto advisor task runs..

Column Datatype NULL Description
AUTO_TASKID NUMBER NOT NULL Unique auto task ID
SNAPID NUMBER   Maximum AWR snapid used to process the segments
SEGMENTS_SELECTED NUMBER   Number of segments chosen for analysis
SEGMENTS_PROCESSED NUMBER   Number of segments actually processed
TABLESPACE_SELECTED NUMBER   Number of tablespaces chosen for analysis
TABLESPACE_PROCESSED NUMBER   Number of tablespaces actually processed
RECOMMENDATIONS_COUNT NUMBER   Number of recommendations generated
START_TIME TIMESTAMP(6)   Time at which the auto task was started
END_TIME TIMESTAMP(6)   Time at which the auto task ended