Oracle Transaction - What Is a Dead Lock

What Is a Dead Lock

Q

What Is a Dead Lock? - Oracle DBA FAQ - Understanding SQL Transaction Management

✍: FYIcenter.com

A

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)

2007-04-17, 4465👍, 0💬

How To View Existing Locks on the Database
How To View Existing Locks on the Database? - Oracle DBA FAQ - Understanding SQL Transaction Management As can see from the pervious tutorial exercise, performance of the second session is greatly affected by the data lock created on the database. To maintain a good performance level for all session... 2007-04-17, 5533👍, 0💬

What Is Open Database Communication (ODBC)
What Is Open Database Communication (ODBC)? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle ... 2007-04-17, 4643👍, 0💬

What Is a Dead Lock
What Is a Dead Lock? - Oracle DBA FAQ - Understanding SQL Transaction Management 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 loc... 2007-04-17, 4466👍, 0💬

How To Experiment a Data Lock
How To Experiment a Data Lock? - Oracle DBA FAQ - Understanding SQL Transaction Management If you want to have some experience with data locks, you can create two windows runing two SQL*Plus sessions. In session 1, you can run a UPDATE statements to create a data lock. Before committing session 2, s... 2007-04-17, 4310👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.