Collections:
How Oracle Handles Dead Locks in Oracle
How Oracle Handles Dead Locks in Oracle?
✍: FYIcenter.com
Oracle server automatically detects dead locks. When a dead lock is detected, Oracle server will select a victim transaction, and fail its statement that is blocked in the dead lock to break the dead lock. The tutorial exercise below shows you an example of statements failed by Oracle server because of dead locks:
(session 1) SQL> connect HR/fyicenter SQL> UPDATE fyi_links SET notes='Session 1' WHERE id=101; 1 row updated. (session 2) SQL> connect HR/fyicenter SQL> UPDATE fyi_links SET notes='Session 2' WHERE id=110; 1 row updated. SQL> UPDATE fyi_links SET notes='Session 2' WHERE id=101; (blocked by lock id=101) SQL> UPDATE fyi_links SET notes='Session 1' WHERE id=110; (blocked by lock on row id=110) ORA-00060: deadlock detected while waiting for resource (statement failed)
2019-08-08, 850👍, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...