skip to main | skip to sidebar

A steaming pile of...

Sunday, March 18, 2007

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

Posted by Andy Hird at 10:56 PM
Labels: database, locks, oracle

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2007 (52)
    • ►  November (1)
    • ►  August (5)
    • ►  July (1)
    • ►  June (11)
    • ►  May (2)
    • ►  April (5)
    • ▼  March (15)
      • TV settop boxes for streaming TV from a media centre
      • Oracle locks
      • One day I may have ADSL2
      • Beatbox!
      • greatpockets.com
      • OMG: Nappy research
      • Alantico solid wood furniture designs
      • E Text Editor. Textmate for Windows
      • Choosing a builder
      • Doujin Shmups
      • 3G-324M video calling
      • Commodore 64 emulator links
      • Verdon Gorge, France
      • Tomato Firmware for Linksys WRT54G
      • store your stem cells
    • ►  February (12)

About Me

Andy Hird
View my complete profile