Andreas_Sprosec_7439

ORA-00060 - deadlock detected

Discussion created by Andreas_Sprosec_7439 on Nov 14, 2017

You Asked

We discovered an ORA-00060 error in the server logs and we asking what does it means
 

And we said …

This ORA-00060 error is generated from Oracle and is captured within our log file.
 

Definition of an ORA-00060 error from the Oracle documentation. 

00060, 00000, "deadlock detected while waiting for resource"

Cause:  Transactions deadlocked one another while waiting for resources. 

Action: Look at the trace file to see the transactions and resources involved. Retry if necessary.
 

The AE SERVER is an event driven/triggered application

Every time an AE OBJECT is activated a STATISTIC entry must be made – AE is a transaction oriented program and can only start with the next transaction when the previous one completed.

AE measures each database statement. If the statement takes more than 1 second this statement is written in the LOG for information. (Message 3524/3525).

AE measures each transaction. If the transaction takes more than 2 seconds this transaction is recorded (Message 3434).

 

Also check out following technical article in our customer portal, please:

How to improve overall Automation Engine performance

Outcomes