Big Update on Busy Table
- From: "Charlotte Hammond" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "charlottejanehammond@xxxxxxxxx" for DMARC)
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Jul 2014 14:07:28 -0700
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
Other related posts:
