This content has been marked as final. Show 4 replies
Unfortunately, there is no guarantee that all data visible via EM pages will be available from the published repository views. In the current case, your best bet would be to query the monitoring views filtered by the database target type.
Thanks for the help.
Unfortunately, there is no guarantee that all data visible via EM pages will be available from the published repository views
well they have to be somewhere, because when you open the chart you can see the values for the last hour. So the data can be obtained. And I don't think that the agent will supply be historic data. Do you agree?
you suggest this view?
select * from MGMT$METRIC_ERROR_HISTORY where target_name='POR.WORLD'
thanks. I think that is it. there are some discrepancies between the following query:
and the GC chart, but I think this is it. just have to parse the data.
select target_name, sum(value) tot_sessions from mgmt$metric_current where (column_label like '%Active Session%' --or column_label like '%Network%' ) and target_name in ('POR.WORLD') and target_type='oracle_database' group by target_name;