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, 1432🔥, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...