topic K8s Oracle database statement missing in purepath calls, Commits and rollbacks in Container platforms

K8s Oracle database statement missing in purepath calls, Commits and rollbacks

steven_torres — Tue, 16 Nov 2021 10:18:55 GMT

Hello I am trying to understand if we are missing a setting in our monitoring. We have a k8s oracle database and I was trying to get some more information on a frequent rollback statement. When I look at the purepath, or the statement details I see "<missing>". I tried to check the commits on that database and in Dynatrace and see the same information. Any insight if this is a limitation of Dynatrace or possibly need to enable something within Dynatrace or the JDBC Sensor. I saw this from some old inquiries on something similar and they mentioned some changes on the JDBC Sensor but I don't know if that also applies to k8s databases...

Any insight would be great.

Re: K8s Oracle database statement missing in purepath calls, Commits and rollbacks

ChadTurner — Thu, 04 Nov 2021 20:18:07 GMT

I would recommend a support ticket on this issue

Re: K8s Oracle database statement missing in purepath calls, Commits and rollbacks

Julius_Loman — Fri, 05 Nov 2021 21:46:03 GMT

@steven_torres this is correct behaviour indeed. You have filter for SQL rollback request. Rollbacks do not have the Database statement. It exists only for SQL modifications, queries and procedures.