What is a deadlock?

There is a table with Pluks('plk') and Zinks ('zin'). Each Pluk only
resides on a single Zink and each Zink may contain multiple Pluks. How
do you find how many Pluks are on each and every Zink? Please provide SQL.

What is a deadlock?

Questions by Namataraginu

Showing Answers 1 - 9 of 9 Answers

sridevip_2008

  • Feb 5th, 2008
 

Deadlock is a process it occurs when two users are trying to modify the same data at the same time, then problem occurs with this process, then oracle automatically locks one user so that other user can process the data.



Sridevi

  Was this answer useful?  Yes

g_sidhu

  • Feb 5th, 2008
 

A deadlock occurs when two or more users are waiting for data locked by each other. When this happens, these users are stuck (deadly embraced) and cannot continue processing.

Oracle automatically detects deadlocks and resolves them by rolling back one of the statements involved in the deadlock, thus releasing one set of data locked by that statement. The session that is rolled back will observe Oracle error: ORA-00060: deadlock detected while waiting for resource.

krishnaindia2007

  • May 16th, 2008
 

Dead lock is a unique situation in multiuser system that causes two or more users to wait indefinately for a locked resource. First user needs a resource locked by the second user and second user needs the resource locked by the first user.To avoid deadlocks avoid using exclusive locks. if using ,  commit the data frequently to release  locks.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions