Home Oracle Commands Oracle Data Dictionary
 v$ Performance views

USER_MVIEW_REFRESH_TIMES

Materialized views and their last refresh times for each master table that the user can look at 

Columns
   ___________________________
 
   LAST_REFRESH
      SYSDATE from the master site at the time of the last refresh
   OWNER
      Owner of the materialized view
   NAME
      The view used by users and applications for viewing the MV
   MASTER_OWNER
      Owner of the master table
   MASTER
      Name of the master table

Related:


Simon Sheppard
SS64.com