Pulling V2 API Oracle Statistics - Anything Special Required?

louis_gallo — Mon, 27 Mar 2023 09:27:52 GMT

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

Re: Pulling V2 API Oracle Statistics - Anything Special Required?

piotr_lugowski — Mon, 27 Mar 2023 09:28:04 GMT

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)

topic Re: Pulling V2 API Oracle Statistics - Anything Special Required? in Dynatrace API

Pulling V2 API Oracle Statistics - Anything Special Required?

Re: Pulling V2 API Oracle Statistics - Anything Special Required?