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]

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

[Joe_Hoffman · Accepted solution]

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.