What Is a Dead Lock in Oracle?
Submitted by: AdministratorA 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:
<pre>(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</pre>
(blocked by lock 2)
(dead lock created)
Submitted by: Administrator
<pre>(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</pre>
(blocked by lock 2)
(dead lock created)
Submitted by: Administrator
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
| ☺ | What Happens to Indexes If You Drop a Table? |
| ☺ | How To Add a New Column to an Existing Table in Oracle? |
| ☺ | How To Invoke the Data Pump Import Utility? |
| ☺ | How To Create Tables for ODBC Connection Testing? |
| ☺ | 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. |
