My Oracle Support Banner

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


Goal

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. 

Solution

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
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.