With regards to handling idle connections, what advice can I give to application team ?
I am assuming like tell them "check sessions are closed properly" like dat?
You haven't answered my question. If "query" is truly blank and it is not just a permission problem, then the issue is not that they fail to close connections after use, but rather that they open connections and then never use them.
