Index

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

A

agents
Database Gateways, 2.3.1
Heterogeneous Services
architecture, 2.1
disabling self-registration, 4.4.2
registering, 4.4, 4.4.1, 4.4.1.1, 4.4.1.2
types of agents, 2.3
Oracle Database Gateway for ODBC, 2.3.2
application development
Heterogeneous Services
controlling array fetches between non-Oracle server and agent, 4.2.3
controlling array fetches between Oracle server and agent, 4.2.2
controlling reblocking of array fetches, 4.2.4
DBMS_HS_PASSTHROUGH package, 3.3
passthrough SQL, 3.3
using bulk fetches, 4.2
using OCI for bulk fetches, 4.2.1
array fetches, 4.2.1
agents, 4.2.3

B

bind queries
executing using passthrough SQL, 3.3.3.2
BIND_INOUT_VARIABLE procedure, 3.3.3, 3.3.3.1.4
BIND_OUT_VARIABLE procedure, 3.3.3, 3.3.3.1.3
BIND_VARIABLE procedure, 3.3.3
buffers
multiple rows, 3.3.3.2
bulk fetches
optimizing data transfers using, 4.2

C

callback link, 3.10.2
CLOSE_CURSOR function, 3.3.3
copying data
from Oracle database server to SQL Server, 4.8
from SQL Server to Oracle database server, 4.9
INSERT statement, 4.9

D

data dictionary views
Heterogeneous Services, 4.10
data type checking support
for remote-mapped statements, 4.5.1
DBMS_HS_PASSTHROUGH package, 3.3.1
list of functions and procedures, 3.3.3
distributed queries
optimizing performance, 5.2
dynamic performance views
Heterogeneous Services, 4.11
determining open sessions, 4.11.2
determining which agents are on host, 4.11.1

E

EXECUTE_IMMEDIATE procedure, 3.3.3
restrictions, 3.3.3.1
EXECUTE_NON_QUERY procedure, 3.3.3

F

FDS_CLASS, 4.4.1.2.1
FDS_CLASS_VERSION, 4.4.1.2.1
FDS_INST_NAME, 4.4.1.2.2
features
new, Preface
FETCH_ROW procedure, 3.3.3
executing queries using passthrough SQL, 3.3.3.2
fetches
bulk, 4.2
optimizing round-trips, 3.3.3.2

G

gateways
how they work, 2.7
GET_VALUE procedure, 3.3.3, 3.3.3.1.3, 3.3.3.1.4

H

Heterogeneous Services
agent registration, 4.4
avoiding configuration mismatches, 4.4.1.1
disabling, 4.4.2
enabling, 4.4.1
self-registration, 4.4.1.2
application development
controlling array fetches between non-Oracle server and agent, 4.2.3
controlling array fetches between Oracle server and agent, 4.2.2
controlling reblocking of array fetches, 4.2.4
DBMS_HS_PASSTHROUGH package, 3.3
passthrough SQL, 3.3
using bulk fetches, 4.2
using OCI for bulk fetches, 4.2.1
data dictionary views, 4.10
types, 4.10.1
understanding sources, 4.10.2
using general views, 4.10.3
using SQL service views, 4.10.5
using transaction service views, 4.10.4
dynamic performance views, 4.11
V$HS_AGENT view, 4.11.1
V$HS_SESSION view, 4.11.2
initialization parameters, 2.5.2, 4.1
SQL service, 2.4.2
transaction service, 2.4.1
HS_AUTOREGISTER initialization parameter
using to enable agent self-registration, 4.4.1.3
HS_BASE_CAPS view, 4.10.1
HS_BASE_DD view, 4.10.1
HS_BULK view, 4.10.1
HS_CLASS_CAPS view, 4.10.1
HS_CLASS_DD view, 4.10.1
HS_CLASS_INIT view, 4.10.1
HS_FDS_CLASS view, 4.10.1
HS_FDS_FETCH_ROWS initialization parameter, 4.2.3
HS_FDS_INST view, 4.10.1
HS_INST_CAPS view, 4.10.1
HS_INST_DD view, 4.10.1
HS_INST_INIT view, 4.10.1
HS_RPC_FETCH_REBLOCKING initialization parameter, 4.2.4
HS_RPC_FETCH_SIZE initialization parameter, 4.2.2, 4.2.4

I

information integration
benefits of Oracle solutions, 1.3
challenges, 1.1
how Oracle addresses, 1.2
Messaging Gateway, 1.2
Open System Interfaces, 1.2
Oracle Streams, 1.2
initialization parameters
Heterogeneous Services (HS), 2.5.2, 4.1
initialization parameters (HS)
common to all gateways, 4.1
purpose, 2.5.2

M

Messaging Gateway
defined, 1.2
multiple rows
buffering, 3.3.3.2

O

OCI
optimizing data transfers using, 4.2.1
Open System Interfaces
defined, 1.2
OPEN_CURSOR procedure, 3.3.3
Oracle Database Gateway for ODBC
Heterogeneous Services, 2.3.2
Oracle Database gateways
optimizing SQL statements, 5.1
Oracle database server
SQL construct processing, 4.5
Oracle Net Services listener, 2.2
Oracle precompiler
optimizing data transfers using, 4.2.1
Oracle Streams
defined, 1.2
using for heterogeneous connectivity, 3.2
OUT bind variables, 3.3.3.1.3

P

PARSE procedure, 3.3.3
passthrough SQL
avoiding SQL interpretation, 3.3
executing statements, 3.3.3
non-queries, 3.3.3.1
queries, 3.3.3.2
with bind variables, 3.3.3.1.1
with IN bind variables, 3.3.3.1.2
with IN OUT bind variables, 3.3.3.1.4
with OUT bind variables, 3.3.3.1.3
implications of using, 3.3.2
overview, 3.3
restrictions, 3.3.2

Q

queries
passthrough SQL, 3.3.3.2

R

reblocking, 4.2.4
remote-mapped statements
and data type checking support, 4.5.1
rows
buffering multiple, 3.3.3.2

S

SQL capabilities
data dictionary tables, 4.10.5.1
SQL service
data dictionary views, 2.6.2, 4.10.1
Heterogeneous Services, 2.4.2
views
Heterogeneous Services, 4.10.5
SQL statements
optimizing distributed, 5.1
Synonyms, 4.7

T

transaction service
Heterogeneous Services, 2.4.1
views
Heterogeneous Services, 4.10.4

U

user-defined functions
executing on non-Oracle database, 4.6

V

variables
bind, 3.3.3.1.1