Re: Many locks on the same table
Date: Mon, 14 Jun 2010 19:55:38 -0700
On Mon, Jun 14, 2010 at 7:43 PM, Alex Octan <alex_at_octan.cz.cc> 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.
Perhaps an explanation of the problems this is causing users, along with platform info: database, os, applications.
Trace files generated?
Programs that run too long?
Application response time?Received on Mon Jun 14 2010 - 21:55:38 CDT