deadlock detected while waiting for resource

Two or more sessions are waiting for resources that the others hold, creating a cycle with no resolution. Oracle automatically detects the deadlock and rolls back one statement in the victim session. The application should retry the transaction. Review locking order in the application to prevent deadlocks.