Resolve ORA-00060 Error Message in Oracle

Learn the reason and how to get to the bottom of the ORA-00060 error message in Oracle.

Description

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

ORA-00060: impasse detected while waiting for useful resource

Cause

You tried to execute a statement, however your session used to be deadlocked because some other session had the same aid 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 had been rolled back.

Option #2

You can execute a ROLLBACK and re-execute all statements on account that the remaining COMMIT was executed.