# Oracle insights and the lost metric splittings

**URL:** <https://community.dynatrace.com/t/oracle-insights-and-the-lost-metric-splittings/31865>\
**Category:** Extensions\
**Tags:** databases, oracle, extensions\
**Created:** [June 20, 2021, 1:43pm UTC](https://community.dynatrace.com/t/oracle-insights-and-the-lost-metric-splittings/31865 "2021-06-20T13:43:52Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![henk\_stobbe](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/henk_stobbe/32/30434_2.png) [@henk\_stobbe](https://community.dynatrace.com/u/henk_stobbe)\
**Post date:** [June 20, 2021, 1:43pm UTC](https://community.dynatrace.com/t/oracle-insights-and-the-lost-metric-splittings/31865/1 "2021-06-20T13:43:52Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Babar\_Qayyum](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/babar_qayyum/32/13620_2.png) [@Babar\_Qayyum](https://community.dynatrace.com/u/Babar_Qayyum)\
**Post date:** [June 20, 2021, 1:54pm UTC](https://community.dynatrace.com/t/oracle-insights-and-the-lost-metric-splittings/31865/2 "2021-06-20T13:54:40Z")

</div>

Hello&nbsp;[@henk\_stobbe](https://community.dynatrace.com/user/11427)

All the Oracle-native metrics fetched by Oracle database insights are available for&nbsp;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/](https://www.dynatrace.com/support/help/how-to-use-dynatrace/databases/database-insights/)

Regards,

Babar

---

<div class="post-metadata">

**Author:** ![AntonioSousa](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antoniosousa/32/50_2.png) [@AntonioSousa](https://community.dynatrace.com/u/AntonioSousa)\
**Post date:** [June 20, 2021, 3:07pm UTC](https://community.dynatrace.com/t/oracle-insights-and-the-lost-metric-splittings/31865/3 "2021-06-20T15:07:09Z")

</div>

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:

 ![AntonioSousa_0-1624201272066.png](https://global.discourse-cdn.com/dynatrace/original/3X/3/a/3aafe8d3f98f16a4e798d40970ee0c46c3c275d0.png)

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:

 ![AntonioSousa_1-1624201528219.png](https://global.discourse-cdn.com/dynatrace/original/3X/4/7/47dea4912b944d09403a30f0316eb2674db02e3c.png)

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

 ![AntonioSousa_2-1624201621629.png](https://global.discourse-cdn.com/dynatrace/original/3X/3/6/36629d34526f59b28d41f83488acf54a74dde190.png)

---

<div class="post-metadata">

**Author:** ![henk\_stobbe](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/henk_stobbe/32/30434_2.png) [@henk\_stobbe](https://community.dynatrace.com/u/henk_stobbe)\
**Post date:** [June 20, 2021, 3:21pm UTC](https://community.dynatrace.com/t/oracle-insights-and-the-lost-metric-splittings/31865/4 "2021-06-20T15:21:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![henk\_stobbe](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/henk_stobbe/32/30434_2.png) [@henk\_stobbe](https://community.dynatrace.com/u/henk_stobbe)\
**Post date:** [June 20, 2021, 3:25pm UTC](https://community.dynatrace.com/t/oracle-insights-and-the-lost-metric-splittings/31865/5 "2021-06-20T15:25:26Z")

</div>

Hi Antonio,

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

KR Henk

---

<div class="post-metadata">

**Author:** ![AntonioSousa](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antoniosousa/32/50_2.png) [@AntonioSousa](https://community.dynatrace.com/u/AntonioSousa)\
**Post date:** [June 20, 2021, 5:02pm UTC](https://community.dynatrace.com/t/oracle-insights-and-the-lost-metric-splittings/31865/6 "2021-06-20T17:02:29Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![henk\_stobbe](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/henk_stobbe/32/30434_2.png) [@henk\_stobbe](https://community.dynatrace.com/u/henk_stobbe)\
**Post date:** [June 21, 2021, 3:27pm UTC](https://community.dynatrace.com/t/oracle-insights-and-the-lost-metric-splittings/31865/7 "2021-06-21T15:27:30Z")

</div>

Hello Antonio,

I would like to split up and filter by statement,

![henk_stobbe_0-1624289192256.png](https://global.discourse-cdn.com/dynatrace/original/2X/b/b887caa577ba79a8ae3ae4faef811a616f880889.png)

 ![henk_stobbe_1-1624289231231.png](https://global.discourse-cdn.com/dynatrace/original/2X/0/0be68cde6e1613f1b339e223563dbf2d47118c99.png)

I know the info is available (-;

KR HEnk

---

<div class="post-metadata">

**Author:** ![AntonioSousa](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antoniosousa/32/50_2.png) [@AntonioSousa](https://community.dynatrace.com/u/AntonioSousa)\
**Post date:** [June 21, 2021, 6:26pm UTC](https://community.dynatrace.com/t/oracle-insights-and-the-lost-metric-splittings/31865/8 "2021-06-21T18:26:26Z")

</div>

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…
