5.185 DBA_AUTO_CLUSTERING_RECOMMENDATIONS
DBA_AUTO_CLUSTERING_RECOMMENDATIONS
displays recommendations associated with automatic clustering.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the table |
|
|
|
Name of the table |
|
|
|
Unique ID representing the recommendation |
|
|
|
Owner of the SQL tuning set that is used for the recommendation |
|
|
|
Name of the SQL tuning set that is used for the recommendation |
|
|
|
Recommended clustering method for the table. Possible values:
A null value means there is no recommended clustering method for the table. |
|
|
|
DDL that was, or would be, used to apply the clustering recommendation to the table A null value means there is no clustering recommendation for the table. |
|
|
|
DDL that was, or would be, used to apply the zone map recommendation to the table A null value means there is no zone map recommendation for the table. |
|
|
|
Mode for the application of the recommendation. Possible values:
|
|
|
|
Date and time at which the application of the recommendation started A null value means the recommendation was not applied. |
|
|
|
Date and time at which the application of the recommendation finished A null value means either the recommendation was not applied or the application of the recommendation is not finished. |
|
|
|
Verification or application status. Possible values:
|
Note:
This view is available starting with Oracle Database 23ai.