Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 09 Aug 2009 @ 21:17:00 GMT


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


Subj:   Re: Get History of blocking.
 
From:   Robert D Meunier

If you'll notice I mention how to get the output logged to a file, so someone doesn't always have to be watching the screen. It isn't the level of detail that you can get with Locking Logger, but it's the only thing I know to do if you don't have Locking Logger turned on to allow you to capture some history.

It'll show you who is blocking who and the object they are blocking on. A little bit of effort could probably get you the SQL that was running for each session.


Robert Meunier



     
  <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