This discussion is archived
8 Replies Latest reply: May 7, 2013 5:35 AM by 1002969 RSS

OEM 12c Metric Value History

1002969 Newbie
Currently Being Moderated
Hello! Sorry for my bad English. I have a problem to see Metric Value History.
Historical data shows only 7 days with the average values for one hour
and after 7 days as the average value of the day. In documentation i found:
Core EM Metric Data Tables and Default Data Retention in the Management
Repository Table                     Name Partitions Retained Partition Size
EM_METRIC_VALUES                               7                          DAY
EM_METRIC_VALUES_HOURLY                     32                          DAY
EM_METRIC_VALUES_DAILY                         12                          MONTH

I changed the values ​​for the following:

execute gc_interval_partition_mgr.set_
retention('SYSMAN', 'EM_METRIC_VALUES', 90);
execute gc_interval_partition_mgr.set_
retention('SYSMAN', 'EM_METRIC_VALUES_HOURLY', 180);
execute gc_interval_partition_mgr.set_
retention('SYSMAN', 'EM_METRIC_VALUES_DAILY', 36);

TABLE_NAME PARTITIONS_RETAINED
------------------------------ -------------------
EM_METRIC_VALUES 90
EM_METRIC_VALUES_HOURLY 180
EM_METRIC_VALUES_DAILY 36


But in EM:
Host->All Metrics->Load->Memory Utilization(%)
still shows the values ​​in the last 7 days as an average over an hour, and 7 days later as the average of the day

how can I shows the values of more than a week? Thanks.
  • 1. Re: OEM 12c Metric Value History
    1002969 Newbie
    Currently Being Moderated
    surely no one has such a problem in Enterprise Manager when you see Metric Value Histroy?
  • 2. Re: OEM 12c Metric Value History
    1003343 Newbie
    Currently Being Moderated
    You can select 'view_data' and select last 31 days or can view data based on 'Custom time period'
  • 3. Re: OEM 12c Metric Value History
    969940 Newbie
    Currently Being Moderated
    I believe modifying the retention time only applies to how long the raw data is kept before purging. You want to modify how often the data is aggregated. I will look into that.

    In the mean time, you should be able to access directly from the repository. Not ideal, but it is a start.
  • 4. Re: OEM 12c Metric Value History
    1002969 Newbie
    Currently Being Moderated
    I will try to explain
    I have raw retention period 90 days

    Host->All metrics->Load->Memory Utilization(%)

    it shows 7 days with average values ​​per hour. Later than 7 days - daily mean values​​.

    [http://img.uz/s?f2h937g]

    I choose the date for April 6 and EM shows me a solid line on the graph, the average for the day, while the bottom shows that the spikes were triggered and restrictions

    [http://img.uz/s?d2h93mj]

    BUT
    If i click on the button "Modify Threshold" i see the correct data
    [http://img.uz/s?g2h94ak]

    general graph in "Modify Threshold"
    [http://img.uz/s?i2h940e]

    BUT if i have no privilege "Modify" I do not see the button "Modify Thresholds" and therefore can not see the correct graph.

    How can I configure the EM to see the graphs in (Host->All metrics->Load->Memory Utilization(%) ) later than 7 days as when you press the button "Modify Thresholds" instead of the average values ​​for day?

    Edited by: 999966 on 16.04.2013 7:59
  • 5. Re: OEM 12c Metric Value History
    1002969 Newbie
    Currently Being Moderated
    up
  • 6. Re: OEM 12c Metric Value History
    strap1972 Newbie
    Currently Being Moderated
    We're having exactly the same issue.... The graph for the Metrics Value History (view data: Last 31 days) only shows details for the last 7 days!
    [http://prntscr.com/11slbm] (graph with a compare of 4 hosts)

    The raw metrics data retention already was changed to 45 days some weeks ago:

    SQL> select table_name, partitions_retained
    2 from em_int_partitioned_tables
    3 where table_name in ('EM_METRIC_VALUES','EM_METRIC_VALUES_HOURLY','EM_METRIC_VALUES_DAILY');

    TABLE_NAME PARTITIONS_RETAINED
    ------------------------------ -------------------
    EM_METRIC_VALUES 45
    EM_METRIC_VALUES_HOURLY 32
    EM_METRIC_VALUES_DAILY 12


    Interesting fact:

    If you "Modify Tresholds..." the tresholds suggestion chart displays the correct information (when for example selecting 31days).
    [http://prntscr.com/11slti]


    Hope there's a fix/solution for this issue?

    Edited by: user961940 on 23-apr-2013 1:48 - added the graph of Modify Tresholds
  • 7. Re: OEM 12c Metric Value History
    1002969 Newbie
    Currently Being Moderated
    up
  • 8. Re: OEM 12c Metric Value History
    1002969 Newbie
    Currently Being Moderated
    Also "Modify Thresholds" shows data only for the last month. Data older than the month tab does not display.
    http://img.uz/s?c2ih4ni
    I need the data over the month.
    Surely no one with such a problem not encountered?

    Edited by: 999966 on 07.05.2013 5:34

    Edited by: 999966 on 07.05.2013 5:34

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points