I have queried a production database thru OEM. All metrics are gathered in OEM repository and are visible in OEM Cloud Control. But if I try to request them using grafana they are limited to 10 objects.
Have you checked the Series: Custom (Repository) in your metric definition in Grafana ? I can see that in your case isRemoteConnection:false, though I would have expected this to be a Remote Repository for Grafana to query the OEM Repository.
The whitepaper following the Grafana plugin’s release
Oracle Enterprise Manager
Oracle Enterprise Manager App for GrafanaUser’s Guide
Or the YouTube video that comes with it:
Monitor DB Performance & Configuration Metrics Using OEM App for Grafana Out-of-the-box Dashboards