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.