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
This view is available starting with Oracle Database 12c Release 2 (220.127.116.11).