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
-
3
Features of Oracle Database Gateways
- SQL and PL/SQL Support
- Heterogeneous Replication
- Passthrough SQL
- Result Set Support
- Data Dictionary Translations
- Date-Time Data Types
- Two-Phase Commit Protocol
- Piecewise LONG Data Type
- SQL*Plus DESCRIBE Command
- Constraints on SQL in a Distributed Environment
- Oracle's Optimizer and Heterogeneous Services
-
4
Using Heterogeneous Services Agents
- Initialization Parameters
- Optimizing Data Transfers Using Bulk Fetch
- Optimizing Data Loads Using Parallel Load
- Registering Agents
- Oracle Database Server SQL Construct Processing
- Executing User-Defined Functions on a Non-Oracle Database
- Using Synonyms to Provide Data Location and Network Transparency
- 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
- Heterogeneous Services Dynamic Performance Views
- 5 Performance Recommendations
- Index