Re: Many locks on the same table

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 14 Jun 2010 19:55:38 -0700
Message-ID: <AANLkTikIIdlgxExy6OWuYlBs5WQx8qbUZ3tlRtAdTRko_at_mail.gmail.com>

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.

Error messages?

Trace files generated?

Programs that run too long?

Application response time?

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 14 2010 - 21:55:38 CDT