RDBPROD: Load Performance With RMU/LOAD And/or 3GLs (Doc ID 65460.1)

Last updated on AUGUST 03, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 3.0 and later
HP OpenVMS VAX
HP OpenVMS Itanium
HP OpenVMS Alpha

Goal

RMU/LOAD is a utility for loading amounts of data from a flat file into a database. RMU/LOAD is often used with RMU/UNLOAD to selectively reorganize parts of a database.

RMU/LOAD can be used to move a large volume of data. Moving large amounts of data can involve performance penalties. This article describes some of the common pitfalls and remedies.

This article describes some techniques commonly used by Database Administrators (DBAs) to improve the performance of RMU/LOAD.

The techniques described in this article also apply to 3GL programs that load data into an Oracle Rdb database.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms