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

Database, Oracle


 


Comments are closed.