Friday, April 23, 2010

ORA-00060 deadlock detected while waiting for resource

Cause: Your session and another session are waiting for a resource locked by

the other. This condition is known as a deadlock. To resolve the deadlock, one

or more statements were rolled back for the other session to continue work.

Action:

Either:

1. Enter a ROLLBACK statement and re-execute all statements since the last

commit or

2. Wait until the lock is released, possibly a few minutes, and then re-execute

the rolled back statements.