All Forums Database
l.k 75 posts Joined 10/08
14 Apr 2010
Killing IDLE sessions Automatically in teradata...


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?


AbeK 24 posts Joined 08/09
14 Apr 2010

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

You must sign in to leave a comment.