My Oracle Support Banner

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

Last updated on APRIL 16, 2024

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

To view full details, 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 a vibrant support community of peers and Oracle experts.