topic Re: Oracle insights and the lost metrics in Extensions

Oracle insights and the lost metric splittings

henk_stobbe — Thu, 24 Jun 2021 10:31:15 GMT

Hello,

Where all all the metrics from oracle insights? I can find them in the GUI but not in the metric list.

I like to to some simple things like plot single query;s response time etc.

KR Henk

Re: Oracle insights and the lost metrics

Babar_Qayyum — Sun, 20 Jun 2021 13:54:40 GMT

Hello @henk_stobbe

All the Oracle-native metrics fetched by Oracle database insights are available for custom charts.

Please have a look at the below link for more insight.

https://www.dynatrace.com/support/help/how-to-use-dynatrace/databases/database-insights/

Regards,

Babar

Re: Oracle insights and the lost metrics

AntonioSousa — Sun, 20 Jun 2021 15:07:09 GMT

The part that you are familiar with is in Tecnologies on the left-side menu, then the "Oracle Database" tile, then the "Oracle Database" group that has a "DB Insignts" in the Source column. You click the associated Oracle database/device and it should take you to a page similar to:

Regarding metrics, they are also available, and do serve for some neat dashboards. In Custom charts, select Technologies, and then "Oracle", and you will get the list:

In Metrics, it's more or less the same, just filter by Oracle:

Re: Oracle insights and the lost metrics

henk_stobbe — Sun, 20 Jun 2021 15:21:40 GMT

Hello Babar,

Thx for your reply, you are correct, but to go a step further the splitting is only per "custom device", so I assume that splittings per query (as an example) can not be done?

KR Henk

Re: Oracle insights and the lost metrics

henk_stobbe — Sun, 20 Jun 2021 15:25:26 GMT

Hi Antonio,

Thanks for your reply, same question/remark as above (-; The splitting are not available per query )-;

KR Henk

Re: Oracle insights and the lost metrics

AntonioSousa — Sun, 20 Jun 2021 17:02:29 GMT

Not sure what you mean by splitting by query? I split by custom device, which in my case splits by Oracle RAC instance.

Re: Oracle insights and the lost metrics

henk_stobbe — Mon, 21 Jun 2021 15:27:30 GMT

Hello Antonio,

I would like to split up and filter by statement,

I know the info is available (-;

KR HEnk

Re: Oracle insights and the lost metrics

AntonioSousa — Mon, 21 Jun 2021 18:26:26 GMT

Gotta it. It would be nice, very nice to see that in a graph, and maybe even in a Dashboard, splitted/filtered by the sqlid. Unfortunately, that's not available... If you put in an RFE, let us know here, so we can upvote it...