How Oracle Handles Dead Locks?
Submitted by: AdministratorOracle 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/globalguideline
SQL> UPDATE ggl_links
SET notes='Session 1'
WHERE id=101;
1 row updated.
<pre> (session 2)
SQL> connect HR/globalguideline
SQL> UPDATE ggl_links
SET notes='Session 2'
WHERE id=110;
1 row updated.
SQL> UPDATE ggl_links
SET notes='Session 2'
WHERE id=101;
(blocked by lock id=101)
SQL> UPDATE ggl_links
SET notes='Session 1'
WHERE id=110;
(blocked by lock on row id=110)
ORA-00060: deadlock
detected w
Submitted by: Administrator
(session 1)
SQL> connect HR/globalguideline
SQL> UPDATE ggl_links
SET notes='Session 1'
WHERE id=101;
1 row updated.
<pre> (session 2)
SQL> connect HR/globalguideline
SQL> UPDATE ggl_links
SET notes='Session 2'
WHERE id=110;
1 row updated.
SQL> UPDATE ggl_links
SET notes='Session 2'
WHERE id=101;
(blocked by lock id=101)
SQL> UPDATE ggl_links
SET notes='Session 1'
WHERE id=110;
(blocked by lock on row id=110)
ORA-00060: deadlock
detected w
Submitted by: Administrator
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
☺ | How To Invoke the Data Pump Import Utility? |
☺ | How To Write Numeric Literals in Oracle? |
☺ | What Happens to Indexes If You Drop a Table? |
☺ | How To Recover a Dropped Table in Oracle? |
☺ | How To Retrieve Data from an Explicit Cursor? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |