This blog will answer the following questions:
- How does a deadlock look like in DB01 Oracle lock monitor?
- How can I solve the issue?
A database deadlock can occur when 2 or more processes are trying to update each other and are also waiting for each other. This process will lead to infinite waiting.
DB01 Oracle lock monitor
With the use of transaction DB01 you can get overview of Oracle locks. A deadlock is observed when the status is on HOLD and more processes are in status WAIT.
Solving the deadlock can be done by the Oracle DBA on database level.
Background: 745639 – FAQ: Oracle enqueues.