Contents

Title and Copyright In formation

Send Us Your Comments

Preface< /font>

Audience

Organization

Related Documentation

< a href="preface.htm#969319">Conventions

Documentation Accessibility

< /dl>

What's New in Heterogeneous Connectivity?

HS_CALL_NAME Initialization Paramete r

1 Introduction< /h3>

The Information Integration Challenge< /strong>

How Oracle Addresses Synchronous Information Integra tion

Benefits of Oracle's Solution for Synchrono us Information Integration

Remote Data Can Be Accessed Transparently

There is No Unnecessary Data Duplication

SQL Statements Can Query Several Different Databases

Oracle's Application Development and End User Tools Can Be Used

Users Can Talk to a Remote Database in its Own Language

2 The Role of the Heterogeneous Services Component

Heterogeneous Connectivity Process Architecture

Heterogeneous Services Agents

Types of Heterogeneous Services Agents

Oracle Transparent Gateways

Generic Connectivity Agen ts

Heterogeneous Services Components

Transaction Service

SQL Service

Configuring Heteroge neous Services

Data Dictionary Translations

Heterogeneous Services Initialization Parameters

Capabilities

The Heterogene ous Services Data Dictionary

Classes and Instances

Data Dictionary Views

Gateway Process Flow

3 Features of Oracle Transparent Gateways and Generic Connectivity

SQL and PL/SQL Support

Heterogeneous Replication

< a href="majfeat.htm#1006051">Pass-Through SQL

Using the DBMS_HS_PASSTHROUGH Package

Considering the Implications of Using Pass-T hrough SQL

Executing Pass-Through SQL Statements

Result Set Support

Result Set Support In Non-Oracle Systems

Heterog eneous Services Support for Result Sets

Data Dictionary Translations

Datetime Datatypes

Two-Phase Commit Protocol

Piecewise Long

SQL*Plus DESCRIBE Command

Constraints on SQL in a Distributed Environment

Resolving Remote and Heterogeneous References

Resolving Important R estrictions

Updates, Inserts, and Deletes

Using Oracle's Optimizer with Heterogeneous Services

Example: Using Index and Table Statistics

Example: Remote Join Optimization

Optimizer Restriction s for Non-Oracle Access

4 Using Heterogeneous Services Agents

Setting Up Access to Non-Oracle Systems

S tep 1: Configure Oracle Net Services to Access Heterogeneous Services Agents

S tep 2: Create the Database Link to the Non-Oracle System

Step 3: Test the Conn ection

Setting Initialization Parameters

Name and Location of Heterogeneous Services Initialization P arameter File

Syntax for Initialization Parameter Settings

Gateway Initialization Parameters

Optimizing Data Transfers Using Bulk Fetch

Using OCI, an Oracle Precompiler, or Another Tool for Array Fetches

Controlling the Array Fetch Between Oracle Database Server and Agent

Control ling the Array Fetch Between Agent and Non-Oracle Server

Controlling the Reblo cking of Array Fetches

Registering Agents

Enabling Agent Self-Registration

Disabling Agent Self-Registration

Oracle Database Server SQL Construct Processing

Executing User-Defined Functions on a Non-Oracle Database

Using Synonyms

Copying Data from the Oracle Database Server to the Non-Oracle Database System

Copying Data from the Non-Oracle Database System to the Oracle Database Server

Heterogeneous Services Data Dictionary Views

Understanding the Types of Views

Understanding the Sources of Data Dictionary Information

Using the General Vi ews

Using the Transaction Service Views

Using the SQL Service Views

Us ing the Heterogeneous Services Dynamic Performance Views

Determining Which Agents Are Running on a Host

Determining the Open Heterog eneous Services Sessions

Determining the Heterogeneous Services Parameters

5 Multithreaded Ag ents

Why Use Multithreaded A gents?

The Challenge of Dedicated Agent Architectur e

The Advantage of Multithreading

Multithreaded Agent Architecture

< a href="multithr.htm#1006013">The Monitor Thread

Dispatcher Threads

Task Threads

Administering Multithreaded Agents

Agent Control Utility (agtctl) Commands

Using Single-Line Command Mode< /a>

Using Shell Mode Commands

Configuration Parameters for Multithreaded Agent Control

6 Performance Tips

Optimizing Heterogeneous Distributed SQL Statements

Optimizing Performance of Distributed Queries

7 Generic Connectivity

< dd class="H1TOC">What Is Generic Connectivity?

Types of Agents

Generic Connectiv ity Architecture

SQL Execution

Datatype Mapping

Generic Connectivity Restrictions

Supported Oracle SQL Statements and Functions

Configuring Generic Connectivity Agents

Creating the Initialization File

Editing the Initialization File

Setting Initialization Parameter s for an ODBC-based Data Source

Setting Initialization Parameters for an OLE DB-based Data Source

ODBC Connectivity Require ments

OLE DB (SQL) Connectivity Requirements

OLE DB (FS) Connectivity Requirements

OLE DB Interfaces for Data Providers to Expose

Data Source Properties

< font face="Arial, Helvetica, sans-serif">A Heterogeneous Services Initialization Parameters

HS_CALL_NAME

HS_COMMIT_POINT_STRENGTH

HS_DB_ DOMAIN

HS_DB_INTERNAL_NAME

HS_DB_NAME

HS_DESCRIBE_CACHE_HWM

HS_FDS_CONN ECT_INFO

ODBC-Based Data Source on Windows

ODBC-Based Data Source on UNIX

OLE DB-Based Data Source (Windows NT Only)

HS_FDS_DEFAULT_SCHE MA_NAME

HS_FDS_SHAREABLE_NAME

HS_FDS_TRACE_LEVEL

HS_LANGUAGE

Character Sets

Language

Territory

HS_LONG_PIECE_TRANSFER_SIZE

HS_NLS_DATE_FORMAT

HS_NLS_DATE_LANGUAGE

HS_NLS_NCHAR< /a>

HS_NLS_NUMERIC_CHARACTER

HS_NLS_TIMESTAMP_FORMAT

HS_NLS_TIMESTAMP_TZ_FORMAT

HS_OPEN_CURSORS

HS_ROWID_CACHE_SIZE

HS_RPC_FETCH_REBLOCKING

< strong class="Bold">HS_RPC_FETCH_SIZE

HS_TIME_ZONE

IFILE

B Datatype Mapping

Mapping ANSI Datatypes to Oracle Datatypes Through an ODB C Interface

Mapping ANSI Datatypes to Oracle Dataty pes Through an OLE DB Interface

C Data Dictionary Translation Support

Accessing the Non-Oracle Data Dictionary

Heterogeneous Services Data Dictionary Views

Vi ews and Tables Supported by Generic Connectivity

Data Dic tionary Mapping

Generic Connectivity Data Dictionary Descriptions

Index