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 |
---|---|---|---|
|
|
Unique task ID generated by the auto advisor |
|
|
|
Name of the tablespace containing the segment |
|
|
|
Owner of the segment |
|
|
|
Name of the segment |
|
|
|
The type of segment (TABLE, INDEX, and so on) |
|
|
|
Name of the subsegment (if partitioned) |
|
|
|
Status of the analysis:
|
|
|
|
Reason why this segment was chosen |
|
|
|
A value associated with the reason |
|
|
|
Time when this entry was created |
|
|
|
Auto advisor task that was used to process the segment/tablespace |
|
|
|
Time at which the advisor task was completed |