ORA-00060: Deadlock detected

[Former Member]

Hi,

I am getting the error "ORA-00060: Deadlock detected" continuously while DB check.( always around 40 to 80 dead locks )

I had checked the trace file ( which is located at /oracle/<SID>/saptrace/usertrace/cep_ora_xxxxx.trc.)

and got the following deadlock graph. As per the sap note 84348 its not an oracle deadlock.

-

---

Blocker(s)--

---

-

---

Waiter(s)--

---

Resource Name process session holds waits process session holds waits

TX-02280006-00046282 440 1467 X 278 1635 X

TX-01ad000b-000eaae2 278 1635 X 440 1467 X

Please suggest me to fix this. How can i clear this deadlocks? (AIX/Oracle)

Thanks & Regards,

Nagendra.

[former_member188883]

Hi,

Firstly monitor the behaviour of your deadlock situation. Whats the duration this deadlock appears.

During that time which all database process oriented jobs are running ..

Such analysis can help you out in figuring out which application is causing such a deadlock.

Hope this helps.

Regards,

Deepak Kori

[sunny_pahuja2]

Hi,

Check SAP Note 84348 - Oracle deadlocks, ORA-00060

Thanks

Sunny

[Former Member]

Hi Nagendra,

As Sunny said, check SAP Note 84348.

You have to patiently read the whole Notes and try to understand whether it is coming from DB or from Application.

Also read Notes 1155807.

regards,

Mohan.