All MarkView Components - Useful Database Lock Troubleshooting Information

Question / Problem: 

Are there scripts/articles that will help diagnose/troubleshoot database locking issues on an Oracle database?

Answer / Solution: 

• The following Oracle Support Articles contain information regarding database locking:

• Useful Oracle Support Articles:

  • Detecting and Resolving Locking Conflicts using TopSessions -Note 164760.1
  • FAQ about detecting and resolving Locking Issues - Note 15476.1
  • How to know which row is locked by what user - Note 132629.1
  • Find Session or User who is Locking Record - Note 74089.1
• Scripts to retrieve locking information:
  • TFTS SCRIPT TO RETURN MEDIUM DETAIL LOCKING INFO - Note 1020012.6
  • TFTS FULLY DECODED LOCKING SCRIPT- Note 1020008.6
  • SCRIPT: DISPLAY LOCKS AND GIVE SID AND SERIAL # TO KILL - Note 1020007.6
  • SCRIPT: DISPLAY SQL TEXT FROM LOCKS - Note 1020010.6
  • SCRIPT: SCRIPT TO DISPLAY USER LOCK INFORMATION - Note 1020047.6
  • SCRIPT: REPORT SESSIONS WAITING FOR LOCKS - Note 1020088.6
  • SCRIPT: dblocking.sql
  • SCRIPT: lockwait.sql

Applies to: