Oracle Deadlock

[Former Member]

Hi Experts,

We are encountering oracle deadlocks recently in our ECC system mainly during begging of the months,

we have implemented various solutions recommended by SAP OSS, but nothing helped.

any suggestions.

Thank you.

Grace.

[Former Member · Accepted solution]

Grace,

Based on you case that deadlock is occurring only during month end/beginning,

Try to narrow down to exact time of the occurrence at least to 1 hour, you may do this by monitoring DB01 and based on user compiling about the issue.

In general a Report/ User/ Bg Job should be the culprit most of the time.

Monitor via DB01 for deadlocks, SM37 for Jobs & Reports running at that time, Deadlock may occur if users are repeatedly accessing(updating) same table or the kind of Report they are using to.

Below is quick SQL query to monitor locks from Oracle level.

sql> select l1.sid, ' IS BLOCKING ', l2.sid  from v$lock l1, v$lock l2  where l1.block =1 and l2.request > 0  and l1.id1=l2.id1  and l1.id2=l2.id2;

You may also keep an eye on Temp Table space, look at Oracle Alert log for abnormalities during that time, Also look at your latest EW report.

[Former Member · Accepted solution]

Hi Raghu,

It was a Report which was causing the issue, not properly tested in QA but transported to Prd system.

[Former Member · Accepted solution]

Hi,

deadlock may happend in each environment

thnaks