What's New in Heterogeneous Connectivity Administrator's Guide?

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:

• Oracle Database 11g Release 1 (11.1) New Features

• Oracle Database 10g Release 2 (10.2) Features

Oracle Database 11g Release 1 (11.1) New Features

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:

  • LOAD_TABLE

    This procedure loads data from a remote table to the local Oracle table in parallel.

  • CREATE_TABLE_TEMPLATE

    This procedure writes out a CREATE TABLE template based on information gathered from the remote table.

  • CREATE_OR_REPLACE_VIEW

    This procedure creates (or replaces) a read-only view to be referenced for retrieving the data from a remote table in parallel.

  • DROP_VIEW

    This procedure drops the view created by the CREATE_OR_REPLACE_VIEW procedure.

  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.

Oracle Database 10g Release 2 (10.2) Features

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.

  See Also:

  Section 4.5, "Oracle Database Server SQL Construct Processing"

• dg4pwd Utility

  Use this utility to encrypt initialization parameters in a Heterogeneous Services Gateway initialization file.

  See Also:

  Section 4.1.1, "Encrypting Initialization Parameters"