Re: Big Update on Busy Table

Unless it is a large column, millions of rows shouldn't take that long. Are we talking tens of millions, hundreds of millions? How big is the column? Can it be parallelized? Have you tried this on a non-prod system to see how long it will take?

Seth Miller

On Wed, Jul 16, 2014 at 4:07 PM, Charlotte Hammond < dmarc-noreply_at_freelists.org> wrote:

> Hi All,
>
> I need to run an update of one column of millions of rows in a busy OLTP
> table. To prevent the transaction blocking other sessions for too long I'm
> planning to break it into updates of a few thousand rows at a time with a
> commit in between. This will prevent any one row being locked for more
> than about a second. However it is tending towards slow-by-slow
> processing: is there a better way of updating this table without creating
> long lived TX locks?
>
> Thanks!
> Charlotte
>

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