totn Oracle Error Messages

Oracle / PLSQL: ORA-00060 Error Message

Learn the cause and how to resolve the ORA-00060 error message in Oracle.

Description

When you encounter an ORA-00060 error, the following error message will appear:

  • ORA-00060: deadlock detected while waiting for resource

Cause

You tried to execute a statement, but your session was deadlocked because another session had the same resource locked. The statement(s) that you tried to execute have been rolled back.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

You can wait a few minutes and try to re-execute the statement(s) that were rolled back.

Option #2

You can execute a ROLLBACK and re-execute all statements since the last COMMIT was executed.