DBA_MVIEW_ANALYSIS

Description of the materialized views accessible to dba
Columns
   ___________________________
 
   INVALID
      Invalidity of the materialized view, Y = INVALID, N = VALID
   OWNER
      Owner of the materialized view
   REWRITE_ENABLED
      This materialized view is enabled for query rewrite
   QUERY_LEN
   QUERY
   KNOWN_STALE
      This materialized view is directly stale
   MVIEW_NAME
      Name of the materialized view
   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
   FULLREFRESHTIM
      The time that it took to fully refresh the materialized view
   REVISION
   INCREFRESHTIM
      The time that it took to incrementally refresh the materialized view
   CONTAINS_VIEWS
      This materialized view contains views in the FROM clause
   UNUSABLE
      This materialized view is unusable, the build was deferred
   RESTRICTED_SYNTAX
      This materialized view contains restrictive syntax
   INC_REFRESHABLE
      This materialized view is not restricted from being incrementally refreshed
   SUMMARY
Related Commands:
Simon Sheppard
SS64.com