ALL_SUMMARIES

Description of the summaries accessible to the user

Columns
   ___________________________
 
   SUMMARY_NAME
      Name of the summary
   CONTAINER_OWNER
      Owner of the container table
   CONTAINER_NAME
      Name of the container table for this summary
   LAST_REFRESH_SCN
      The SCN of the last transaction to refresh the summary
   LAST_REFRESH_DATE
      The date of the last refresh of the summary
   REFRESH_METHOD
      User declared method of refresh for the summary
   SUMMARY
      Indicates the presence of either aggregation or a GROUP BY
   FULLREFRESHTIM
      The time that it took to fully refresh the summary
   INCREFRESHTIM
      The time that it took to incrementally refresh the summary
   CONTAINS_VIEWS
      This summary contains views in the FROM clause
   UNUSABLE
      This summary is unusable,the build was deferred
   RESTRICTED_SYNTAX
      This summary contains restrictive syntax
   INC_REFRESHABLE
      This summary is not restricted from being incrementally refreshed
   KNOWN_STALE
      This summary is directly stale
   QUERY_LEN
      --
   QUERY
      --

Related:


© Copyright SS64.com 1999-2014
Some rights reserved