DBA_AUTO_MV_ANALYSIS_REPORT

DBA_AUTO_MV_ANALYSIS_REPORT reports on analyses and 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)   The name of the task execution with which this entry (row) is associated
SEQUENCE NUMBER NOT NULL Sequence number of the journal entry (unique for each task). This sequence number is used to order the data.
MESSAGE VARCHAR2(4000)   Entry in the journal