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)`		Not currently used
`ZONEMAP_DDL`	`VARCHAR2(4000)`		Not currently used
`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 AI Database 26ai.