This section describes new features of the Oracle Database 11g Release 1 (11.1) and provides pointers to additional information. New features information from previous releases is also retained to help those users migrating to the current release.
The following sections describe the new features in Oracle Database Heterogeneous Connectivity Administrator's Guide:
New features for Oracle Database 11g Release 1 (11.1) in the Heterogeneous Connectivity Administrator's Guide include:
Parallel data retrieval
The Heterogeneous Services agent architecture has been enhanced for parallel data retrieval from non-Oracle remote databases. With this feature, gateway customers experience improved elapsed time for data retrieval and load.
This feature includes the new
DBMS_HS_PARALLEL package. Four new procedures are introduced with this package:
This procedure loads data from a remote table to the local Oracle table in parallel.
This procedure writes out a
CREATE TABLE template based on information gathered from the remote table.
This procedure creates (or replaces) a read-only view to be referenced for retrieving the data from a remote table in parallel.
This procedure drops the view created by the
See Also:Oracle Database PL/SQL Packages and Types Reference for additional information
Optimizer interface improvements
The statistics interface of Heterogeneous Services has been enhanced to enable the Oracle optimizer to derive an equivalent execution plan for distributed SQL when dealing with a remote Oracle database and the agent. With this feature, customers experience similar or better elapsed time for distributed SQL across the gateways.
New features for Oracle Database 10g Release 2 (10.2) in the Heterogeneous Connectivity Administrator's Guide include:
Data type checking
This release adds data type checking for remote-mapped statements. The result provides consistent data type checking and complete data type coercion.
Use this utility to encrypt initialization parameters in a Heterogeneous Services Gateway initialization file.