I am working with ERP Projects, where there are around 1000 users,accessing tables,doing transction, we are also using the concept of transaction for our projects. I am always facing a problem of Table Lock it's goes into wait and then not wakeup. At that time i used to kill that process,but by killing it's affect all transaction,insert,deletion records get hampered connected with each other.
So kindly suggest me what should i do to avoid table lock/ what should be the structure (just summary).
I have also tried google but not found right answer/or i am unable to get/i have not got right link.
Kindly suggest me.