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
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
No comments:
Post a Comment