1/45

Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Heterogeneous Connectivity

• The Information Integration Challenge
• How Oracle Addresses Synchronous Information Integration
• Benefits of Oracle's Solution for Synchronous Information Integration
  • Remote Data Can Be Accessed Transparently
  • No Unnecessary Data Duplication
  • SQL Statements Can Query Several Different Databases
  • Oracle's Application Development and End User Tools Can Be Used
  • Users Can Communicate With 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 Database Gateways
  • Oracle Database Gateway for ODBC Agent
• Heterogeneous Services Components
  • Transaction Service
  • SQL Service
• Heterogeneous Services Configuration Information
  • Data Dictionary Translation Views
  • Heterogeneous Services Initialization Parameters
  • Capabilities
• Heterogeneous Services Data Dictionary
  • Classes and Instances
  • Data Dictionary Views
• Process Flow for non-Oracle Database Queries

3 Features of Oracle Database Gateways

• SQL and PL/SQL Support
• Heterogeneous Replication
  • Example: Creating Materialized Views for Heterogeneous Replication
  • Example: Setting Up a Refresh Group for Heterogeneous Replication
  • Example: Forcing Refresh of All Three Materialized Views
• Passthrough SQL
  • DBMS_HS_PASSTHROUGH Package
  • Implications of Using Passthrough SQL
  • Executing Passthrough SQL Statements
    • Executing Nonqueries
      • Overview of Bind Variables
      • IN Bind Variables
      • OUT Bind Variables
      • IN OUT Bind Variables
    • Executing Queries
• Result Set Support
  • Result Set Support for Non-Oracle Systems
  • Heterogeneous Services Support for Result Sets
    • Results Sets: Cursor Mode
    • Result Sets: Sequential Mode
• 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
  • Remote and Heterogeneous References
  • Rules and Restrictions When Using SQL for Remote Mapping in a Distributed Environment
• Oracle's Optimizer and Heterogeneous Services
  • Example: Using Index and Table Statistics
  • Example: Remote Join Optimization
  • Optimizer Restrictions for Non-Oracle Access
  • Explain Plan Consideration

4 Using Heterogeneous Services Agents

• Initialization Parameters
  • Encrypting Initialization Parameters
    • Using the dg4pwd Utility
  • 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 and the Agent
  • Controlling the Array Fetch Between the Agent and the Non-Oracle System
  • Controlling the Reblocking of Array Fetches
• Optimizing Data Loads Using Parallel Load
• Registering Agents
  • Enabling Agent Self-Registration
    • Using Agent Self-Registration to Avoid Configuration Mismatches
    • Understanding Agent Self-Registration
      • FDS_CLASS and FDS_CLASS_VERSION
      • FDS_INST_NAME
    • Specifying HS_AUTOREGISTER
  • Disabling Agent Self-Registration
• Oracle Database Server SQL Construct Processing
  • Data Type Checking Support for a Remote-Mapped Statement
• Executing User-Defined Functions on a Non-Oracle Database
• Using Synonyms to Provide Data Location and Network Transparency
  • Example: A Distributed Query
• 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
  • Types of Views
  • Sources of Data Dictionary Information
  • General Views
  • Transaction Service Views
  • SQL Service Views
    • Views for Capabilities and Translations
    • Views for Data Dictionary Translations
• Heterogeneous Services Dynamic Performance Views
  • Determining Which Agents Are Running on a Host: V$HS_AGENT View
  • Determining the Open Heterogeneous Services Sessions: V$HS_SESSION View
  • Determining the Heterogeneous Services Parameters: V$HS_PARAMETER View

5 Performance Recommendations

• Optimizing Heterogeneous Distributed SQL Statements
• Optimizing Performance of Distributed Queries

Index