1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE
  4. DBA_AUTO_MV_ANALYSIS_REPORT

5.182 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

Note:

This view is available starting with Oracle Database 21c.