Skip to main content
Kofax

All MarkView Components - Useful Database Lock Troubleshooting Information

4335
4335
304089

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:  

Product Version Category
MarkView All Troubleshooting

 

Author:  Aidan Sullivan

8/6/2019 - Copied from CRM

  • Was this article helpful?