Topic : Dead locks
What is deadlocks?
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.