Many locks on the same table
Date: Mon, 14 Jun 2010 23:43:57 -0300
I have a system that one table has million of rows and many sessions doing operations, and because of this many locks are happening. So I was thinking what kind of initiative I can take on this. Perhaps partitioning, or indexes, or does anybody have other actions that I can take a look??
Thanks in advance for the help.