DBA_MVIEW_ANALYSIS

Description of the materialized views accessible to dba

Columns
   ___________________________
 
   OWNER
      Owner of the materialized view
   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
   SUMMARY
      --
   FULLREFRESHTIM
      The time that it took to fully refresh the materialized view
   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
   KNOWN_STALE
      This materialized view is directly stale
   INVALID
      Invalidity of the materialized Y = INVALID,N = VALID
   REWRITE_ENABLED
      This materialized view is enabled for query rewrite
   QUERY_LEN
      The length (in bytes) of the query field
   QUERY
      SELECT expression of the materialized view definition
   REVISION
      Reserved for internal use


© Copyright SS64.com 1999-2014
Some rights reserved