Home Oracle Commands Oracle Data Dictionary
 v$ Performance views

DBA_BASE_TABLE_MVIEWS

All materialized views with log(s) in the database 

Columns
   ___________________________
 
   OWNER
      Owner of the master table which changes are logged
   MASTER
      Name of the master table which changes are logged
   MVIEW_LAST_REFRESH_TIME
      One date per materialized view -- the date the materialized view was last refreshed
   MVIEW_ID
      Unique identifier of the materialized view

Related:


Simon Sheppard
SS64.com