Optimizing Data Loads Using Parallel Load

The DBMS_HS_PARALLEL PL/SQL package enables parallel processing when accessing heterogeneous targets. 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; all procedures in this package are executed with the privileges of the calling user.

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