Return
-
Title
Error: "ORA-00060: deadlock detected while waiting for resource" -
Description
Post has known to stop on both MTP and STP due to this error: "ORA-00060: deadlock detected while waiting for resource". -
Cause
Deadlock occurs because another session had the same resource locked. -
Resolution
WORKAROUND:
Restart post
STATUS:
An enhancement request has been submitted for future release for post to retry when it encounters deadlock errors, instead of exiting, as maybe during the retry the resources will become available and post will be able to continue. -
Defect ID
CR24606