Lock Table Overflow

[#1]

Hi,

We had an "Lock table overflow"  issue for 30mins in our production system.. Without performing any manual actions locks got cleared after 1hr.
Now, the requirement for us is to identify who has chewed up all the resources to cause lock table overflow.. is there any way, where i can able to find out which user/transaction/program has made to happen lock overflow.

I had gone through couple of Note, SAP Recomended to update enque/table_size to avoid this problem. But, without identifying reason we don't want to increase the parameter. As, well as i also checked in STAD. But, i unable to find the exact information. Thanks in Advance.

Regards,

Raj

[Former Member]

Hi Raj,

- Checked the table on which the update was happening. if it is the same table then you need to run the statistics on the table.

- Checked the dialog work process status as well and how many dialog process were available at that time.

You can follow the link as suggested by Divyanshu.

With Regards

Ashutosh Chaturvedi