0 Replies Latest reply: Dec 11, 2012 2:47 PM by 694143 RSS

    Which table contains collected values of metric key in EM repos?

    694143
      I've a metric group which has a metric key. When queying the collected values for the metric group, I don't see the metric key values from the result.

      select METRIC_GROUP_NAME, METRIC_COLUMN_NAME, VALUE
      from GC_METRIC_VALUES_LATEST
      where METRIC_GROUP_NAME = '<metric name>';

      Using the oracle_database [Type]/database [instance]/'Archive Area'[metric group] as example, 'Archive Area Destination' is the metric key.
      Run this query:
      select METRIC_GROUP_NAME, METRIC_COLUMN_NAME, VALUE
      from GC_METRIC_VALUES_LATEST
      where ENTITY_guid = (select target_guid from mgmt_targets where target_name ='database' and target_type='oracle_database')
      and METRIC_GROUP_NAME = 'archFull';

      result:
      archFull     archTotal     195570068
      archFull     archUsed     76805980
      archFull     archUsedPercent     42
      archFull     archAvail     118764088

      Where I can find collected values of the metric key?