DBA_AUTO_SEGADV_SUMMARY
provides a summary of the auto advisor task runs.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique auto task ID |
|
|
Maximum AWR snapid used to process the segments |
|
|
|
Number of segments chosen for analysis |
|
|
|
Number of segments actually processed |
|
|
|
Number of tablespaces chosen for analysis |
|
|
|
Number of tablespaces actually processed |
|
|
|
Number of recommendations generated |
|
|
|
Time at which the auto task was started |
|
|
|
Time at which the auto task ended |