OEM 13c Monitoring Features – Part 3, Reports Based on Metric Data
This is the third in a series of blog posts covering the most important topics you should know to completely monitor your IT infrastructure with Oracle Enterprise Manager Cloud Control 13c. The previous posts covered how to set up basic monitoring and how to use extended metrics.
Below is an example of the actual report:
And here is the query used in the report:
SELECT collection_timestamp, target_name, value FROM mgmt$metric_details WHERE metric_name = ’ME$PENDING_CALLS’ AND metric_column = ‘CALLS’ AND collection_timestamp > SYSDATE-10 ORDER BY 1;