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)
Â
2019-08-08, 1065👍, 0💬
Popular Posts:
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...