On Tue, Sep 26, 2023 at 10:04 AM Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx> wrote:
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.
Cheers,
Jeff