Re: Many locks on the same table
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: alex@xxxxxxxxxxx
- Date: Tue, 15 Jun 2010 08:14:03 +0100
The appropriate action, if any, would depend on what is actually happening.
You talk about many operations and many locks, but don't give examples of
either. This makes any meaningful response somewhat problematic.
Niall Litchfield
On Jun 15, 2010 3:46 AM, "Alex Octan" <alex@xxxxxxxxxxx> wrote:
Hi folks,
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.
Alex
Other related posts:
