5.185 DBA_AUTO_CLUSTERING_RECOMMENDATIONS

DBA_AUTO_CLUSTERING_RECOMMENDATIONS displays recommendations associated with automatic clustering.

Column	Datatype	NULL	Description
TABLE_OWNER	VARCHAR2(128)	NOT NULL	Owner of the table
TABLE_NAME	VARCHAR2(128)	NOT NULL	Name of the table
RECOMMENDATION_ID	RAW(16)	NOT NULL	Unique ID representing the recommendation
SQLSET_OWNER	VARCHAR2(128)		Owner of the SQL tuning set that is used for the recommendation
SQLSET_NAME	VARCHAR2(128)		Name of the SQL tuning set that is used for the recommendation
CLUSTERING_METHOD	VARCHAR2(8)		Recommended clustering method for the table. Possible values: SINGLE - Single table clustering (clustering is based on columns from a single table) JOIN - Join clustering (clustering is based on columns from two or more tables that are joined together) A null value means there is no recommended clustering method for the table.
CLUSTERING_DDL	VARCHAR2(4000)		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.
ZONEMAP_DDL	VARCHAR2(4000)		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.
APPLY_MODE	VARCHAR2(16)		Mode for the application of the recommendation. Possible values: FULL - Data clustered using online redefinition INCREMENTAL - Data clustered incrementally
APPLY_START_TIMESTAMP	TIMESTAMP(6) WITH TIME ZONE		Date and time at which the application of the recommendation started A null value means the recommendation was not applied.
APPLY_END_TIMESTAMP	TIMESTAMP(6) WITH TIME ZONE		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.
STATUS	VARCHAR2(16)	NOT NULL	Verification or application status. Possible values: ACCEPTED FAILED IMPLEMENTED REJECTED UNVERIFIED

Note:

This view is available starting with Oracle Database 23ai.