topic Re: Oracle DB Leak Connection in Open Q&A

Oracle DB Leak Connection

gauresh_shinde — Mon, 09 Jan 2023 05:18:23 GMT

Hi All,

We need to find oracle DB leak connection associate with which request/service?

Regards,
Gauresh

Re: Oracle DB Leak Connection

Mizső — Mon, 09 Jan 2023 08:43:58 GMT

I have only experience with Weblogic + Oracle, I can not define which request / service associated with the leaked connection. I can define only the affected data source. It is provided by the Weblogic connection pool monitoring feature. There are connection pool monitoring features for the other technologies also, but I do not know those possibilities.

Best regards,

Mizső

Re: Oracle DB Leak Connection

AntonioSousa — Mon, 09 Jan 2023 21:29:43 GMT

@gauresh_shinde,

This blog post has some details on how it works:
https://www.dynatrace.com/news/blog/simplify-troubleshooting-with-ai-powered-insights-into-connection-pool-performance-early-adopter/

Beware that you have to have JMX configured in your Application Server. It really doesn't depend on the database being used. You can then configure one of them for your use-case: