Hi Scott, I agree with you. I would like to see all locks, the owner of the lock and who is blocked by the lock. When I find the query that does this I will post i here.
Thanks,
Susan
Hi Marco, thank you. Is there an add on that supports DBA tasks? I'm not a DBA so I don't need very advanced tools, but I do need to be able to kill the blocking locks in the system without having to click through every user to see which one has locks. I would think this would be a common...
Hello, I am evaluating this product to see if it provides all of the features I currently use in Toad. In the Sessions window, I am trying to figure out a way to see locks across all sessions. Many times a developer will call and ask if there is a blocking lock. In Toad, I can see all locks in...