Archives of the TeradataForum
Message Posted: Sun, 09 Aug 2009 @ 21:17:00 GMT
| 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
| 
