How to see how many deadloacks are?

[Former Member]

Hi Friends!

In working in BI, and sometimes my process were cancelled by deadlock.

How can I verify if there are or how many deadlocks are in the database?

[anindya_bose · Accepted solution]

SAP Note 84348 - Oracle deadlocks might help you in analyzing...

Regards

Anindya

[stefan_koehler]

Hello,

> In working in BI, and sometimes my process were cancelled by deadlock.

Your information is pretty less ..

but in BI deadlocks are pretty easy to produce, if you still have BITMAP indexes on your tables through the loading process.

So many ways ... so less information.

Regards

Stefan

[Former Member]

Hi,

You can programme a daily CheckDB in DB13. There you will have the deadlocks of each day:

 
BR0974I Checking database messages in /oracle/<SID>/saptrace/background/alert_<SID>.log ...
BR0976W Database message alert - level: WARNING, line: 793248, time: 2010-05-24 20.50.10, message:
ORA-00060: Deadlock detected. More info in file /oracle/<SID>/saptrace/usertrace/gep_ora_1616.trc.

Best regards,

Martina

[markus_doehr2]

Deadlocks are "not in the database", they occur if one process A waits for a lock on process B and B waits for the same on A.

You can check SM21 and ST22 which tables/cubes are affected.

Markus