Many locks on the same table
From: Alex Octan <alex_at_octan.cz.cc>
Date: Mon, 14 Jun 2010 23:43:57 -0300
Message-ID: <AANLkTimFZUyIMWbL_06G2fDAgZtpBaTGxG8MUzMrQX6y_at_mail.gmail.com>
Hi folks,
Date: Mon, 14 Jun 2010 23:43:57 -0300
Message-ID: <AANLkTimFZUyIMWbL_06G2fDAgZtpBaTGxG8MUzMrQX6y_at_mail.gmail.com>
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 Mon Jun 14 2010 - 21:43:57 CDT