This section describes new features of the Oracle Database 11g Release 2 (11.2) and provides pointers to additional information. New features information from previous releases is retained to help those users migrating to the current release.
The following sections describe the new features in Oracle Database Heterogeneous Connectivity User's Guide:
New features for Oracle Database 11g Release 2 (11.2) in the Oracle Database Heterogeneous Connectivity User's Guide include:
This feature allows any HS-based gateway to optionally run in
CHAR Semantics mode. Rather than always describing non-Oracle database columns as
BYTE), this new feature describes them as
CHAR). The concept is similar to Oracle Database
Multi-byte character sets ratio suppression
This feature optionally suppresses the ratio expansion from the non-Oracle database involving multi-byte character set (for example, from
AL32UTF8, or from
KO16KSC5601). By default, Oracle Gateways assume the worst ratio to prevent data being truncated or insufficient buffer size situation.
This release fully supports IPv6 between Oracle Database and Oracle Database gateways. For some gateways, IPv6 is also supported between Oracle Database gateways and the non-Oracle targets.
Gateway IDLE timeout
This release allows some Gateways to specify a session idle timeout limit. When a gateway session is idle for more than the specified time limit, the gateway session is terminated automatically with any pending update rolled back (if the gateway has the proper rollback capability).
See Also:For additional information, consult the Oracle documentation for that specific gateway
New features for Oracle Database 11g Release 1 (11.1) in the Oracle Database Heterogeneous Connectivity User's Guide include:
Parallel data retrieval
The Heterogeneous Services agent architecture was enhanced for parallel data retrieval from remote non-Oracle 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 the data from a remote table to a local Oracle table in parallel. If the local Oracle table does not already exist, it is created automatically.
This procedure writes out a
CREATE TABLE template based on information gathered from the remote table. You can use the information to add any optimal Oracle
CREATE TABLE clauses.
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 and internal objects created by the
CREATE_OR_REPLACE_VIEW procedure. If the view has not already been created by the
CREATE_OR_REPLACE_VIEW procedure, an error message is returned.
Optimizer interface improvements
The statistics interface of Heterogeneous Services was 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.