SYS.V$TTSTATS_ELEMENT_AGGR

This view contains data about aggregated metrics.

Usage with TimesTen Scaleout

This view contains data for the local element.

Usage with TimesTen Classic

This view exists in TimesTen Classic, but contains no data.

Columns

Column name Type Description

ID

TT_BIGINT NOT NULL

The snapshot identifier

METRIC_NAME

VARCHAR2(64) INLINE NOT NULL

The name of the metric that is aggregated

METRIC_MIN

TT_BIGINT NOT NULL

The minimum value of the metric for the aggregation interval

METRIC_MAX

TT_BIGINT NOT NULL

The maximum value of the metric for the aggregation interval

METRIC_MEAN

TT_BIGINT NOT NULL

The average value of the metric for the aggregation value

AGGR_PERIOD

VARCHAR2(2) INLINE NOT NULL

The unit of aggregation. Valid values are:

  • YR: Year

  • MT: Month

  • DY: Day

  • HR: Hour

  • MI: Minute

COLLECTED_AT

TT_TIMESTAMP NOT NULL

The time when the snapshot was collected

ELEMENTID

TT_INTEGER NOT NULL

The element from which the snapshot was collected