Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Tell us about your experience with the "Oracle Enterprise Manager App for Grafana ”
Answers
-
Hi Murtaza,
[grafana.ini]
enable_alpha = true
allow_loading_unsigned_plugins = oracle-emcc-app
plugin_admin_external_manage_enabled = true
Grafana8. 31 the configuration is as above, but the OEM plug-in cannot be used because the plug-in is not signed. Please ask grafana8 31 is there an OEM plug-in available?
The plug-in cannot be updated directly here in grafana.
-
Hi May I know version of the Plug-in/App you are using? Also is there a reason why you are using Grafana Server 8 version?
-
Plug in: 2.0.0
Grafana:8.3.1
Reason for using grafana: grafana < = 8.3.0 has "grafana arbitrary file reading 0day vulnerability"
-
Current version of plugin v2.0 has not been tested with Grafana 8.3.1. Recommendation is to use v7.3.1.
-
The results of Time series queries seem to be limited to 10.
Is there a way to remove this restriction?
In the screen below, there are tablespaces named TEST01-TEST10, but only TEST01-TEST05 are displayed.
Grafana v7.3.7
OEM App for Grafana v2.0.0
Enterprise Manager v13.5.0.0
-
In the upcoming version, we are removing that restriction. Till then, as a work-around, you can write custom repository query to display the results which you are interested in.
-
Thank you for your reply.
I'm looking forward to the upcoming version.
-
I can also only display metrics for the last 7 days although the repository has the data far further back. Will this restriction also be removed or is there a way to configure this already?
-
In the Series drop-down, instead of Raw, if you select Hourly or Daily then you will be able to see beyond 7 days data. Please check EM documentation about the reason behind these options: https://docs.oracle.com/cd/E73210_01/EMADM/GUID-A3CDCD1E-294D-4472-82A7-F2CD30D8D9BA.htm#EMADM12782. Look Table 20-1 Default Repository Purging Policies
In case of Hourly and Daily options, the datapoint value will be basically an aggregated value, so you have options like Average,Standard Deviation etc to choose as per your requirements.
-
Thank you very much for the reply, I actually wasn't aware that the series types like raw and hourly correspond to different sources in EM.
We use grafana mostly for real-time views for which raw is best suited but sometimes we would want to see what happened 3 months ago, before a major change in the application, to compare the performance.
It would be very handy if the plugin could handle this automatically. As a feature request, would it be possible to have an "adaptive" time series in a future update? If the time picked is lower than the raw purging time it takes the data from the raw view, lower than hourly it takes it from the hourly view and so on? This would make the view seamless and provide near real time- as well as historical data.
The other options for our needs I guess are to either create a "historical" version of our dashboard or to use custom queries which would pick the views adaptively, not an easy task with the 30 panels we have in our dashboard.
