Scripts for Object Locks and Blocking Sessions. Blocking Session using v$lock SELECT    l1.sid || ‘ is blocking ‘ || l2.sid blocking_sessions FROM    v$lock l1, v$lock l2 WHERE    l1.block = 1 AND    l2.request > 0 AND    l1.id1 = l2.id1 AND    l1.id2 = l2.id2; Blocking session with More information SELECT s1.username … Continue reading Scripts for Locks and Blocking sessions