Index

A B C D E F G H I M O P Q R S T U V

A

agents
- Database Gateways [1]
- Heterogeneous Services
  - architecture [1]
  - disabling self-registration [1]
  - registering [1] , [2] , [3] , [4]
  - types of agents [1]
- Oracle Database Gateway for ODBC [1]
application development
- Heterogeneous Services
  - controlling array fetches between non-Oracle server and agent [1]
  - controlling array fetches between Oracle server and agent [1]
  - controlling reblocking of array fetches [1]
  - DBMS_HS_PASSTHROUGH package [1]
  - passthrough SQL [1]
  - using bulk fetches [1]
  - using OCI for bulk fetches [1]
array fetches
- agents [1]

B

BIND_INOUT_VARIABLE procedure [1]
BIND_OUT_VARIABLE procedure [1]
bind queries
- executing using passthrough SQL [1]
buffers
- multiple rows [1]
bulk fetches
- optimizing data transfers using [1]

C

callback link [1]
copying data
- from Oracle database server to SQL Server [1]
- from SQL Server to Oracle database server [1]
- INSERT statement [1]

D

data dictionary views
- Heterogeneous Services [1]
data type checking support
- for remote-mapped statements [1]
DBMS_HS_PASSTHROUGH package [1]
distributed queries
- optimizing performance [1]
dynamic performance views
- Heterogeneous Services
  - determining open sessions [1]
  - determining which agents are on host [1]

E

EXECUTE_IMMEDIATE procedure
- restrictions [1]

F

FDS_CLASS [1]
FDS_CLASS_VERSION [1]
FDS_INST_NAME [1]
fetches
- bulk [1]
- optimizing round-trips [1]

G

gateways
- how they work [1]
GET_VALUE procedure [1]

H

Heterogeneous Services
- agent registration
  - avoiding configuration mismatches [1]
  - disabling [1]
  - enabling [1]
  - self-registration [1]
- application development
  - controlling array fetches between non-Oracle server and agent [1]
  - controlling array fetches between Oracle server and agent [1]
  - controlling reblocking of array fetches [1]
  - DBMS_HS_PASSTHROUGH package [1]
  - passthrough SQL [1]
  - using bulk fetches [1]
  - using OCI for bulk fetches [1]
- data dictionary views
  - types [1]
  - understanding sources [1]
  - using general views [1]
  - using SQL service views [1]
  - using transaction service views [1]
- dynamic performance views
  - V$HS_AGENT view [1]
  - V$HS_SESSION view [1]
- initialization parameters [1] , [2]
- SQL service [1]
- transaction service [1]

I

information integration
- benefits of Oracle solutions [1]
- challenges [1]
- how Oracle addresses [1]
- Messaging Gateway [1]
- Open System Interfaces [1]
- Oracle Streams [1]
initialization parameters
- Heterogeneous Services (HS) [1] , [2]
initialization parameters (HS)
- common to all gateways [1]
- purpose [1]

M

Messaging Gateway
- defined [1]
multiple rows
- buffering [1]

O

OCI
- optimizing data transfers using [1]
Open System Interfaces
- defined [1]
Oracle Database Gateway for ODBC
- Heterogeneous Services [1]
Oracle Database gateways
- optimizing SQL statements [1]
Oracle database server
- SQL construct processing [1]
Oracle Net Services listener [1]
Oracle precompiler
- optimizing data transfers using [1]
Oracle Streams
- defined [1]
- using for heterogeneous connectivity [1]
OUT bind variables [1]

P

passthrough SQL
- avoiding SQL interpretation [1]
- executing statements
  - non-queries [1]
  - queries [1]
  - with bind variables [1]
  - with IN bind variables [1]
  - with IN OUT bind variables [1]
  - with OUT bind variables [1]
- implications of using [1]
- overview [1]
- restrictions [1]

Q

queries
- passthrough SQL [1]

R

reblocking [1]
remote-mapped statements
- and data type checking support [1]
rows
- buffering multiple [1]

S

SQL capabilities
- data dictionary tables [1]
SQL service
- data dictionary views [1] , [2]
- Heterogeneous Services [1]
- views
  - Heterogeneous Services [1]
SQL statements
- optimizing distributed [1]
Synonyms [1]

T

transaction service
- Heterogeneous Services [1]
- views
  - Heterogeneous Services [1]

U

user-defined functions
- executing on non-Oracle database [1]

V

variables
- bind [1]