How to build a lock escalation tree?
Hello!
Concurrent users lock many rows in different tables. Sometimes
one session waits to lock row, which is locked by another
session.
Locks are made by SQL statements.
I would like to present tree of SQL statements which lock (first
level) and as children SQL - statements waiting for release lock
by their parents.
It would be very helpul in finding dependencies and app places,
where deadlock can occur.
Do you know system SQL statement or tool, which could produce
result I need?
TIA,
Witek