Re: Many locks on the same table
- From: Jared Still <jkstill@xxxxxxxxx>
- To: alex@xxxxxxxxxxx
- Date: Mon, 14 Jun 2010 19:55:38 -0700
On Mon, Jun 14, 2010 at 7:43 PM, 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.
>
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
Other related posts:
