Archives of the TeradataForum
Message Posted: Wed, 15 Jan 2003 @ 20:04:16 GMT
| Subj: || || Re: An Idle question |
| From: || || Walter, Todd A |
There is no resource impact on Teradata if the sessions are truly idle. No tasks are held. Minimal memory is used to remember the
session context. No cost to have the session logged on.
If a user leaves a lock behind though, then there could be a negative effect on other users or jobs. eg "BT; Update Customer Where
state='CA'; go home for the day" leaves a write lock outstanding on Customer until they come back and ET; This plus the security issue
mentioned in another messages causes most people to set an idle timeout for sessions.