Big Update on Busy Table
From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Wed, 16 Jul 2014 14:07:28 -0700
Message-ID: <1405544848.76436.YahooMailNeo_at_web162204.mail.bf1.yahoo.com>
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
Date: Wed, 16 Jul 2014 14:07:28 -0700
Message-ID: <1405544848.76436.YahooMailNeo_at_web162204.mail.bf1.yahoo.com>
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-lReceived on Wed Jul 16 2014 - 23:07:28 CEST