Author: techfox9
Finding Oracle locks ..
Monday, October 8th, 2012 @ 11:52 am
From: http://www.orafaq.com/node/854
SQL> select * from v$lock ; SQL> select l1.sid, ' IS BLOCKING ', l2.sid 2 from v$lock l1, v$lock l2 3 where l1.block =1 and l2.request > 0 4 and l1.id1=l2.id1 5 and l1.id2=l2.id2 SQL> /