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, 1433🔥, 0💬
Popular Posts:
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...