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

Generic Connectivity, 2.3.2

Heterogeneous Services

architecture, 2.1

disabling self-registration, 4.3.2

registering, 4.3, 4.3.1, 4.3.1.1, 4.3.1.2

types of agents, 2.3

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

pass-through 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 pass-through 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

character sets

Heterogeneous Services, A.11.1

CLOSE_CURSOR function, 3.3.3

commit point site

commit point strength, A.2

copying data

from Oracle database server to SQL Server, 4.7

from SQL Server to Oracle database server, 4.8

INSERT statement, 4.8

D

data dictionary views

Heterogeneous Services, 4.9

data type checking support

for remote-mapped statements, 4.4.1

date formats

Heterogeneous Services, A.13, A.17

DBMS_HS_PASSTHROUGH package, 3.3.1

list of functions and procedures, 3.3.3

describe cache high water mark

definition, A.6

distributed queries

optimizing performance, 5.2

dynamic performance views

Heterogeneous Services, 4.10

determining open sessions, 4.10.2

determining which agents are on host, 4.10.1

E

EXECUTE_IMMEDIATE procedure, 3.3.3

restrictions, 3.3.3.1

EXECUTE_NON_QUERY procedure, 3.3.3

F

FDS_CLASS, 4.3.1.2.1

FDS_CLASS_VERSION, 4.3.1.2.1

FDS_INST_NAME, 4.3.1.2.2

FETCH_ROW procedure, 3.3.3

executing queries using pass-through SQL, 3.3.3.2

fetches

bulk, 4.2

optimizing round-trips, 3.3.3.2

G

gateways

how they work, 2.7

Generic Connectivity

Heterogeneous Services, 2.3.2

generic connectivity

error tracing, A.10

GET_VALUE procedure, 3.3.3, 3.3.3.1.3, 3.3.3.1.4

globalization support

Heterogeneous Services, A.11

character set of non-Oracle source, A.15

date format, A.13

languages in character date values, A.14

H

Heterogeneous Services

agent registration, 4.3

avoiding configuration mismatches, 4.3.1.1

disabling, 4.3.2

enabling, 4.3.1

self-registration, 4.3.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

pass-through SQL, 3.3

using bulk fetches, 4.2

using OCI for bulk fetches, 4.2.1

data dictionary views, 4.9

types, 4.9.1

understanding sources, 4.9.2

using general views, 4.9.3

using SQL service views, 4.9.5

using transaction service views, 4.9.4

defining maximum number of open cursors, A.19

dynamic performance views, 4.10

V$HS_AGENT view, 4.10.1

V$HS_SESSION view, 4.10.2

initialization parameters, 2.5.2, 4.1, A

optimizing data transfer, A.21

setting global name, A.5

specifying cache high water mark, A.6

specifying cache size, A.20

specifying commit point strength, A.2

SQL service, 2.4.2

transaction service, 2.4.1

tuning internal data buffering, A.22

tuning LONG data transfer, A.12

HS_AUTOREGISTER initialization parameter

using to enable agent self-registration, 4.3.1.3

HS_BASE_CAPS view, 4.9.1

HS_BASE_DD view, 4.9.1

HS_CALL_NAME initialization parameter, A.1

HS_CLASS_CAPS view, 4.9.1

HS_CLASS_DD view, 4.9.1

HS_CLASS_INIT view, 4.9.1

HS_COMMIT_POINT_STRENGTH initialization parameter, A.2

HS_DB_NAME initialization parameter, A.5

HS_DESCRIBE_CACHE_HWM initialization parameter, A.6

HS_FDS_CLASS view, 4.9.1

HS_FDS_CONNECT_INFO initialization parameter, A.7

HS_FDS_DEFAULT_SCHEMA_NAME initialization parameter, A.8

HS_FDS_FETCH_ROWS initialization parameter, 4.2.3

HS_FDS_INST view, 4.9.1

HS_FDS_SHAREABLE_NAME initialization parameter, A.9

HS_FDS_TRACE_LEVEL initialization parameter, A.10

HS_INST_CAPS view, 4.9.1

HS_INST_DD view, 4.9.1

HS_INST_INIT view, 4.9.1

HS_LANGUAGE initialization parameter, A.11

HS_LONG_PIECE_TRANSFER_SIZE initialization parameter, A.12

HS_NLS_DATE_FORMAT initialization parameter, A.13

HS_NLS_DATE_LANGUAGE initialization parameter, A.14

HS_NLS_NCHAR initialization parameter, A.15

HS_NLS_NUMERIC_CHARACTER initialization parameter, A.16

HS_NLS_TIMESTAMP_FORMAT initialization parameter, A.17

HS_NLS_TIMESTAMP_TZ_FORMAT initialization parameter, A.18

HS_OPEN_CURSORS initialization parameter, A.19

HS_ROWID_CACHE_SIZE initialization parameter, A.20

HS_RPC_FETCH_REBLOCKING initialization parameter, 4.2.4, A.21

HS_RPC_FETCH_SIZE initialization parameter, 4.2.2, 4.2.4, A.22

HS_TIME_ZONE initialization parameter, A.23

I

IFILE initialization parameter, A.24

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, A

initialization parameters (HS)

common to all gateways, 4.1

descriptions, A

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

ODBC connectivity

specifying connection information

UNIX, A.7.2

Windows NT, A.7.1

specifying path to library, A.9

Open System Interfaces

defined, 1.2

OPEN_CURSOR procedure, 3.3.3

Oracle database server

SQL construct processing, 4.4

Oracle Net Services listener, 2.2

Oracle precompiler

optimizing data transfers using, 4.2.1

Oracle Streams

defined, 1.2

Oracle Transparent Gateways

optimizing SQL statements, 5.1

OUT bind variables, 3.3.3.1.3

P

PARSE procedure, 3.3.3

pass-through 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

pass-through SQL, 3.3.3.2

R

reblocking, 4.2.4

remote functions

referenced in SQL statements, A.1

remote-mapped statements

and data type checking support, 4.4.1

rows

buffering multiple, 3.3.3.2

S

SQL capabilities

data dictionary tables, 4.9.5.1

SQL service

data dictionary views, 2.6.2, 4.9.1

Heterogeneous Services, 2.4.2

views

Heterogeneous Services, 4.9.5

SQL statements

optimizing distributed, 5.1

Streams

using for heterogeneous connectivity, 3.2

Synonyms, 4.6

T

transaction service

Heterogeneous Services, 2.4.1

views

Heterogeneous Services, 4.9.4

U

user-defined functions

executing on non-Oracle database, 4.5

V

variables

bind, 3.3.3.1.1