1. Database Heterogeneous Connectivity User's Guide
  2. Using Heterogeneous Services Agents
  3. Optimizing Data Loads Using Parallel Load

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.

See Also:

Oracle Database PL/SQL Packages and Types Reference

Parent topic: Using Heterogeneous Services Agents