Exclusive Lockwaits (Oracle)
You can use this procedure to display exclusive lockwaits.
Alternatively, use transaction codeST04.
Exclusive lockwaits are displayed here. A lockwait means that at least one process is locked through a lock held by another process. A request waits for a resource which is locked exclusively by another user. The process holding the lock and the waiting process(es) are displayed.