DBA_MVIEWS

All materialized views in the database
Columns
   ___________________________
 
   LAST_REFRESH_TYPE
      Indicates the kind of refresh that was last performed on the MV
   AFTER_FAST_REFRESH
      Indicates the staleness state the MV will have after a fast refresh is done
   COMPILE_STATE
      Indicates the validity of the MV meta-data
   LAST_REFRESH_DATE
      The date that the materialized view was last refreshed
   REWRITE_CAPABILITY
      Indicates the kind of rewrite that is enabled
   FAST_REFRESHABLE
      Indicates the kinds of operations that can be fast refreshed for the MV
   BUILD_MODE
      How and when to initially build (load) the materialized view container
   REFRESH_METHOD
      The default refresh method for the materialized view (complete, fast, ...)
   REFRESH_MODE
      Indicates how and when the materialized view will be refreshed
   REWRITE_ENABLED
      Indicates whether rewrite is enabled for the materialized view
   MVIEW_NAME
      Name of the materialized view
   CONTAINER_NAME
      Name of the materialized view container table
   MASTER_LINK
      Name of the database link to the master site
   QUERY
      The defining query that the materialized view instantiates
   QUERY_LEN
      The number of bytes in the defining query (based on the server character set
   UPDATABLE
      Indicates whether the materialized view can be updated
   UPDATE_LOG
      Name of the table that logs changes to an updatable materialized view
   MASTER_ROLLBACK_SEG
      Name of the rollback segment to use at the master site
   OWNER
      Owner of the materialized view
   STALENESS
      Indicates the staleness state of the materialized view (fresh, stale, ...)
Related Commands:
Simon Sheppard
SS64.com