DBA_AUTO_MV_ANALYSIS_RECOMMENDATIONS

5.133 DBA_AUTO_MV_ANALYSIS_RECOMMENDATIONS

DBA_AUTO_MV_ANALYSIS_RECOMMENDATIONS displays recommendations associated with automatic materialized views.

Column Datatype NULL Description

Column	Datatype	NULL	Description
`TASK_NAME`	`VARCHAR2(128)`		Name of the task The value of this column is always `SYS_AUTO_MV_TASK`.
`EXECUTION_NAME`	`VARCHAR2(128)`	`NOT NULL`	The name of the task execution with which this entry (row) is associated
`RECOMMENDATIONS`	`CLOB`		Recommendation for the task

TASK_NAME

VARCHAR2(128)

Name of the task

The value of this column is always SYS_AUTO_MV_TASK.

EXECUTION_NAME

VARCHAR2(128)

NOT NULL

The name of the task execution with which this entry (row) is associated

RECOMMENDATIONS

CLOB

Recommendation for the task

Note:

This view is available starting with Oracle Database 21c.