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


© Copyright SS64.com 1999-2014
Some rights reserved