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 |
|
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 |