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, 1178👍, 0💬
Popular Posts:
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...