Many locks on the same table

  • From: Alex Octan <alex@xxxxxxxxxxx>
  • To: Oracle I List <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 14 Jun 2010 23:43:57 -0300

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

Other related posts: