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_MAINT_REPORT

5.185 DBA_AUTO_MV_MAINT_REPORT

DBA_AUTO_MV_MAINT_REPORT displays maintenance operation details associated with automatic materialized view refresh.

Column Datatype NULL Description

SWAT_MM_START_TIME

DATE

Date and time of the maintenance invocation

MESSAGE

VARCHAR2(4000)

Message associated with the materialized view maintenance action

Note:

This view is available starting with Oracle Database 21c.