Is there a way to find out who(if any) has lock on a table ? Basically I am
trying to do an insert update transaction and it is waiting and waitin until
I hit cancel. Since the application heavily uses transactions/commits I am
assuming somewhere it is leaving something open because of which the
following queries are not updating.
Thanks
Mir