ORA-00060 deadlock detected while waiting for resource

What causes an ORA-00060 error?

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.

How Xynomix can help


Enter a ROLLBACK statement and re-execute all statements since the last commit or
Wait until the lock is released, possibly a few minutes, and then re-execute the rolled back statements.

Contact us for more information. To learn more about ways we can support your database visit our Oracle database consultancy page.

Contact Us

    On submitting this form, Xynomix will store your details and may contact you in relation to your request. For more information on how we process data, please see our privacy notice.

    “We have utilised Xynomix consultancy for multiple projects. Most recently we have enlisted their consultants help to complete an Oracle database migration to new servers. As part of this Xynomix used their specialist knowledge to set up an appropriate backup and data retention policy in line with industry best practice. The work was, as always, completed in a timely, efficient manner.”
    aston university

    Leave a comment