USER_MVIEW_AGGREGATES

Description of the materialized view aggregates created by the user

Columns
   ___________________________
 
   MEASURE
      The SQL text of the measure, excluding the aggregation function
   OWNER
      Owner of the materialized view
   MVIEW_NAME
      Name of the materialized view
   POSITION_IN_SELECT
      Position of this aggregated measure with the SELECT list
   CONTAINER_COLUMN
      Name of this column in the container table
   AGG_FUNCTION
      Name of the aggregation function, one of the following:COUNT, SUM, MIN, MAX, AVG, VARIANCE, STDDEV
   DISTINCTFLAG
      Set to Y is this is a DISTINCT aggregation

Related Commands:

Simon Sheppard
SS64.com