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)
⇒ Managing Oracle User Accounts, Schema and Privileges
⇐ What Is a Dead Lock in Oracle
2019-08-08, 1616🔥, 0💬
Popular Posts:
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...