topic Re: Oracle long running queries not available in Extensions

Oracle long running queries not available

AurelienGravier — Mon, 25 Mar 2024 14:41:13 GMT

Hello the community,

I'm using the extension V2.0 Oracle Database in version 2.15 on several database servers.
Contrary to what I see on the hub, I don't have access to long-running queries :

And I use followings features set :

It's important to me, especially for environments where the OneAgent isn't compatible with frontend frameworks.

This feature was available in the older extension named "Oracle DB Insight".

Are you facing the same limitations as me?

Thank you very much. Regards Aurélien.

Re: Oracle long running queries not available

Julius_Loman — Mon, 25 Mar 2024 14:49:12 GMT

@AurelienGravier You don't have the TopN feature enabled which covers this feature. This includes the top intensive queries and the results are sent as log entries to Dynatrace.

Re: Oracle long running queries not available

AurelienGravier — Mon, 25 Mar 2024 14:55:33 GMT

Thank you @Julius_Loman , Do you know if this feature set is only available for early adopter ?

Re: Oracle long running queries not available

AurelienGravier — Mon, 25 Mar 2024 15:18:37 GMT

After enabling the feature set "TopN" it works like a charm, thank you @Julius_Loman.

I was disturbed by what the 'feature set' was displaying (there is no metric for this feature set, yet).

Re: Oracle long running queries not available

Julius_Loman — Mon, 25 Mar 2024 15:28:32 GMT

Nope... this is slightly misleading... It does not contain any metrics, it contains just logs. It needs an improvement here - not just display metrics, but also other sources - @michal_nalezin. FYI.