Optimizing Data Loads Using Parallel Load

Feature 19427

The DBMS_HS_PARALLEL PL/SQL package enables parallel processing for heterogeneous targets access. This package improves performance when retrieving data from a large foreign table.

DBMS_HS_PARALLEL is compiled with an authorization ID of CURRENT_USER, meaning it uses invoker's rights. In other words, all procedures in this package are executed with the privileges of the calling user.

For additional information about the procedures, see Oracle Database PL/SQL Packages and Types Reference.