4.3 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.