Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_MVIEW_REFRESH_TIMES

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

Columns
   ___________________________
 
   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
   LAST_REFRESH
      SYSDATE from the master site at the time of the last refresh

Related:


Simon Sheppard
 SS64.com