cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Pulling V2 API Oracle Statistics - Anything Special Required?

louis_gallo
Helper

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

1 REPLY 1

piotr_lugowski
Dynatrace Enthusiast
Dynatrace Enthusiast

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) 

Featured Posts