Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 19 Jun 2003 @ 18:15:03 GMT


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


Subj:   Re: Locking and Dead Lock Issue
 
From:   Pradeep

No I have not qualified this explicit lock for write command. If I try this then there will be always table lock no row level lock. This will add wait time in another users execution time.

We are using set auto commit false before calling Stored Procedure. I don't have any idea how long the lock will be there on table, is it till SQL got executed or I do explicit commit or till I set auto commit true.



     
  <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: 15 Jun 2023