RDBPROD: Fast Update on Large Tables with Frequent COMMITs
(Doc ID 564575.1)
Last updated on FEBRUARY 05, 2020
Applies to:Oracle Rdb Server on OpenVMS - Version 7.2.2 and later
HP OpenVMS Itanium
HP OpenVMS Alpha
A request is made to update each column of a large table. Using just one UPDATE over all rows may lead to a very big, long running transaction. It might be better to perform frequent commits, but we wish to avoid the overhead of manually managing the subsets of the rows.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document