Re: Idle_session_timeout

You need to talk to your application team and find out about their
connection related timeouts. Things like max-idle-time, server-lifetime,
etc. (They almost certainly use a db library which implements some kind of
client side connection pool).
In short: their timeouts should be lower than the server's
idle_session_timeout.
Something like: max-idle-time < server-lifetime < idle_session_timeout

On Wed, 4 Oct 2023 at 17:41, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
wrote:

> Hi all,
>
> I was facing issue with idle connections not closed.
>
> So, I thought of automating it and set the parameter idle_session_timeout
> to 5min. But I got a message from application team that they are getting
> jdbc error continuously and they are saying connection is getting
> terminated. So I had to turn it off now.
>
>
> How to use this parameter correctly?
>
>