5.176 DBA_AUTO_MV_ANALYSIS_RECOMMENDATIONS

DBA_AUTO_MV_ANALYSIS_RECOMMENDATIONS displays recommendations associated with automatic materialized views.

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

Note:

This view is available starting with Oracle Database 21c.