Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_SUMMARY_AGGREGATES

Data Dictionary View

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:



Simon Sheppard
SS64.com