This content has been marked as final. Show 3 replies
looks like your application forgets to close the DB Connection - this is what a Connection Leak means.
There are tools to identify the offending code - where you acquire the connection
you can try with WLDF:
(profile connection leak)
Thanks for the reply.
I have profiled my application code and did not find any unclosed connections. Moreover I am not able to reproduce this problem on any of my environments (DEV, QA, UAT). It's just happening on PROD and last two days the Leaked Connection count remained same as what is was on April 22 2012.
If my application have any unclosed connection problems, the count should have increased by now but that did not happen.
The message points out that it happens only when connections are not closed properly but I do not think that is the case. I am completely out of options.
I think official Oracle support would be needed for this.