Archive for October, 2012

 

Finding Oracle locks ..

Oct 08, 2012 in Database, Oracle

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> /