Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 15 Jan 2003 @ 20:04:16 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


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.



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016