Re: Many locks on the same table
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 15 Jun 2010 08:14:03 +0100
Message-ID: <AANLkTim2elThi-_9mxl46dx5jbGM0LWdnZ97y54r1BHP_at_mail.gmail.com>
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.
Date: Tue, 15 Jun 2010 08:14:03 +0100
Message-ID: <AANLkTim2elThi-_9mxl46dx5jbGM0LWdnZ97y54r1BHP_at_mail.gmail.com>
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_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.
Alex
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 15 2010 - 02:14:03 CDT