Pulling V2 API Oracle Statistics - Anything Special Required?

[louis_gallo]

Is there anything special required for pulling Oracle statistics from the V2 API? (Token privs? Special parameters?) I can see the statistics in the UI, but when I try pulling them, I get no results. Regular generic statistics pull fine.

This works fine:

API call - https://xxxxxxxx.live.dynatrace.com/api/v2/metrics/query?metricSelector=builtin:host.cpu.usage&resolution=1m&from=now-1h&to=now&entitySelector=type(HOST),tag("MyApplication:ora-rac") 

This one does not work:

API call - https://xxxxxxxx.live.dynatrace.com/api/v2/metrics/query?metricSelector=builtin:tech.oracleDb.pgi.wait.time&resolution=1m&from=now-1h&to=now&entitySelector=type(HOST),tag("MyApplication:ora-rac") 

Any help is appreciated.

Lou

[piotr_lugowski · Accepted solution]

Hi, most likely you should use builtin:tech.oracleDb.cd.wait.time metric key, not the one with pgi in name.
https://xxxxxxx.live.dynatrace.com/api/v2/metrics/query?metricSelector=builtin:tech.oracleDb.cd.wait.time&resolution=1m&from=now-1h&to=now&entitySelector=type(HOST),tag(%22CignaApplication:ora-rac%22)