Collections:
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
2019-08-08, 1527🔥, 0💬
Popular Posts:
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...