Saturday, September 10, 2011

How to check the locks in 11g

Join the v$session and v$lock dba views and get the blocked sessions.
Locking session should be blocking the other session that's interested in the same row or segment.
Posted by at

1 comment:

  1. Venkat DuvvuriMay 16, 2013 at 7:12 AM

    select s.SID,s.SERIAL#,s.USERNAME,s.LOCKWAIT,s.STATUS,l.LMODE,l.BLOCK,l.REQUEST,l.SID from v$session s,v$lock l where S.SID=L.SID;

    ReplyDelete

Subscribe to: Post Comments (Atom)