1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_ZONEMAPS
  4. USER_MVREF_STATS

6.518 USER_MVREF_STATS

USER_MVREF_STATS shows the REFRESH_ID associated with each refresh run of each materialized view for the database that is accessible to the current user. It also provides some basic timing statistics related to that materialized view’s refresh in that run.

Its columns (except for MV_OWNER) are the same as those in DBA_MVREF_STATS.

Note:

This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).

See Also:

"DBA_MVREF_STATS"