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_member618864]

Hi,

Thanks All for your tremendous replies and quick turn- around.. Much appreciated all your efforts..Reagan Benjamin has given wiki link which i have been looking for..

Thanks once again all of you.

Regards,

Raj