Re: Many locks on the same table

From: Jared Still <>
Date: Mon, 14 Jun 2010 19:55:38 -0700
Message-ID: <>

On Mon, Jun 14, 2010 at 7:43 PM, Alex Octan <> 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: Home Page:

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

Original text of this message