USER_MVIEW_ANALYSIS

Description of the materialized views created by the user
Columns
   ___________________________
 
   INCREFRESHTIM
      The time that it took to incrementally refresh the materialized view
   RESTRICTED_SYNTAX
      This materialized view contains restrictive syntax
   MVIEW_TABLE_OWNER
      Owner of the container table
   CONTAINER_NAME
      Name of the container table for this materialized view
   LAST_REFRESH_SCN
      The SCN of the last transaction to refresh the materialized view
   LAST_REFRESH_DATE
      The date of the last refresh of the materialized view
   REFRESH_METHOD
      User declared method of refresh for the materialized view
   SUMMARY
   MVIEW_NAME
      Name of the materialized view
   CONTAINS_VIEWS
      This materialized view contains views in the FROM clause
   OWNER
      Owner of the materialized view
   INC_REFRESHABLE
      This materialized view is not restricted from being incrementally refreshed
   KNOWN_STALE
      This materialized view is directly stale
   INVALID
      Invalidity of the materialized view, Y = INVALID, N = VALID
   REWRITE_ENABLED
      This materialized view is enabled for query rewrite
   QUERY_LEN
   QUERY
   REVISION
   FULLREFRESHTIM
      The time that it took to fully refresh the materialized view
   UNUSABLE
      This materialized view is unusable, the build was deferred
Related Commands:
Simon Sheppard
SS64.com