Oracle Error ORA-00060: deadlock detected while waiting for resource

Oracle Error Message

ORA-00060: deadlock detected while waiting for resource

Reason for the Error

Your session and another session are both waiting for a resource that the other has locked.

This is referred to as a deadlock.

To break the impasse, one or more statements were rolled back so that the other session could continue working. In simple words, You attempted to execute a statement, but your session was stalled because another session had locked the same resource.

The statement(s) you attempted to execute have been reverted.

Solution

You can attempt to re-execute the statement(s) that were rolled back after a brief delay. (OR) All statements that have been executed since the last COMMIT can be re-executed by performing a ROLLBACK.