Topic : Dead locks

What is deadlocks?

Answer :

A deadlock occurs when two transactions hold locks and each is waiting for a lock held by the other session. In the sample sessions below; two users hold clashing locks. Oracle detects this deadlock condition (usually within a couple of seconds) and raises an exception in one of the sessions.

Show Answer Discuss