topic Is it possible to fully monitor DB calls for a Java process that uses an Oracle Listener to talk to the Oracle DB? in Open Q&A

Is it possible to fully monitor DB calls for a Java process that uses an Oracle Listener to talk to the Oracle DB?

D_Miller — Fri, 24 Apr 2020 16:32:32 GMT

Hello,

We have a Java Process that is making calls to an Oracle DB but it is using the Oracle Listener process on the Oracle Host rather than JDBC to make the calls.

Is it possible to get full monitoring of the SQL as we would have if the Java process was using JDBC?

Regards

Re: Is it possible to fully monitor DB calls for a Java process that uses an Oracle Listener to talk to the Oracle DB?

Joe_Hoffman — Fri, 24 Apr 2020 17:38:49 GMT

Dynatrace captures SQL text thru the JDBC driver within the application tier. I assume you're referring to the TNS Listener that runs (normally) on the Database server. I don't believe the TNS Listener uses JDBC and therefore Dynatrace will not automatically capture the SQL text when database connections are initiated thru the TNS listener.