DBA_SUMMARY_AGGREGATES

Columns
   ___________________________
 
   OWNER
      Owner of the summary
   SUMMARY_NAME
      Name of the summary
   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
   MEASURE
      The SQL text of the measure,excluding the aggregation function

Related: