What Is a Dead Lock in Oracle


What Is a Dead Lock in Oracle?

✍: FYIcenter.com


A dead lock is phenomenon happens between two transactions with each of them holding a lock that blocks the other transaction as shown in the following diagram:

(transaction 1)                (transaction 2)
update row X to create lock 1
                               update row Y to create lock 2
                               update row X
                               (blocked by lock 1)
update row Y
(blocked by lock 2)

(dead lock created)


How Oracle Handles Dead Locks in Oracle

Show Existing Locks on the Database in Oracle

Understanding SQL Transaction Management in Oracle

⇑⇑ Oracle Database Tutorials

2019-08-08, 1465🔥, 0💬