Table of Contents
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
- 1 Introduction to Heterogeneous Connectivity
-
2
The Role of the Heterogeneous Services Component
- 2.1 Heterogeneous Connectivity Process Architecture
- 2.2 Heterogeneous Services Agents
- 2.3 Types of Heterogeneous Services Agents
- 2.4 Heterogeneous Services Components
- 2.5 Heterogeneous Services Configuration Information
- 2.6 Heterogeneous Services Data Dictionary
- 2.7 Process Flow for non-Oracle Database Queries
-
3
Features of Oracle Database Gateways
- 3.1 SQL and PL/SQL Support
- 3.2 Heterogeneous Replication
- 3.3 Passthrough SQL
- 3.4 Result Set Support
- 3.5 Data Dictionary Translations
- 3.6 Date-Time Data Types
- 3.7 Two-Phase Commit Protocol
- 3.8 Piecewise LONG Data Type
- 3.9 SQL*Plus DESCRIBE Command
- 3.10 Constraints on SQL in a Distributed Environment
- 3.11 Oracle's Optimizer and Heterogeneous Services
-
4
Using Heterogeneous Services Agents
- 4.1 Initialization Parameters
- 4.2 Optimizing Data Transfers Using Bulk Fetch
- 4.3 Optimizing Data Loads Using Parallel Load
- 4.4 Registering Agents
- 4.5 Oracle Database Server SQL Construct Processing
- 4.6 Executing User-Defined Functions on a Non-Oracle Database
- 4.7 Using Synonyms to Provide Data Location and Network Transparency
- 4.8 Copying Data from the Oracle Database Server to the Non-Oracle Database System
- 4.9 Copying Data from the Non-Oracle Database System to the Oracle Database Server
- 4.10 Heterogeneous Services Data Dictionary Views
- 4.11 Heterogeneous Services Dynamic Performance Views
- 5 Performance Recommendations
- Index