Killing IDLE sessions Automatically in teradata...

Database
l_k
Enthusiast

Killing IDLE sessions Automatically in teradata...

Hi,

I heard that most of the databases are killing the sessions automatically but i think not in teradata.I saw
no. of IDLE sessions which are sitting IDLE more than 4 days in the Teradata manager--> Session Managemnet-->Idle.

Sometimes due to this reason,No.of users threshold is exceeding than the limit set and generating errors via our BI Application.

Is there any option to kill the IDLE sessions automatically?

Thanks.
Tags (1)
1 REPLY
Enthusiast

Re: Killing IDLE sessions Automatically in teradata...

Through Teradata Manager 'Sessions' Tab, you could configure the 'IDLE For(Minutes)' Rule based on number of minutes the session is IDLE.