Oracle locks

Some useful links describing how Oracle locks work and how you can work out who is locking what, and who is blocking who:



who is blocking who: http://orafaq.com/node/854



http://www.adp-gmbh.ch/ora/concepts/lock.html





show locks for more than 2 mins: http://www.psoug.org/reference/locks.html



who is locking what: http://www.dba-oracle.com/t_locked_rows_user_locks.htm