Index

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

A

agent control utility. See agtctl.

agents

Generic Connectivity, 2-4

Heterogeneous Services

architecture, 2-2

disabling self-registration, 4-14

registering, 4-10, 4-11, 4-12

types of agents, 2-3

multithreaded Heterogeneous Services, 5-1

specifying initialization parameters for, 4-3

Transparent Gateways, 2-3

agtctl, 5-3, 5-6

commands, 5-7

shell mode commands, 5-11

single-line command mode, 5-8

application development

Heterogeneous Services

controlling array fetches between non-Oracle server and agent, 4-9

controlling array fetches between Oracle server and agent, 4-9

controlling reblocking of array fetches, 4-9

DBMS_HS_PASSTHROUGH package, 3-5

pass-through SQL, 3-5

using bulk fetches, 4-7

using OCI for bulk fetches, 4-8

array fetches, 4-8

agents, 4-9

B

bind queries

executing using pass-through SQL, 3-11

BIND_INOUT_VARIABLE procedure, 3-7, 3-11

BIND_OUT_VARIABLE procedure, 3-6, 3-10

BIND_VARIABLE procedure, 3-6

buffers

multiple rows, 3-12

bulk fetches

optimizing data transfers using, 4-7

C

character sets

Heterogeneous Services, A-8

CLOSE_CURSOR function, 3-6

commit point site

commit point strength, A-3

configuring

Generic Connectivity, 7-7

Transparent Gateways, 4-2

copying data

from Oracle database server to SQL Server, 4-18

from SQL Server to Oracle database server, 4-19

INSERT statement, 4-19

D

data dictionary

contents with Generic Connectivity, C-5

mapping for Generic Connectivity, C-5

Oracle server name/SQL Server name, C-5

translation support for Generic Connectivity, C-1

data dictionary views

Generic Connectivity, C-5

Heterogeneous Services, 4-20, C-2

database links

heterogeneous systems, 4-3

date formats

Heterogeneous Services, A-9, A-11

DBMS_HS_PASSTHROUGH package, 3-5

list of functions and procedures, 3-6

describe cache high water mark

definition, A-5

dispatcher threads

multithreaded Heterogeneous Services agents, 5-3, 5-5

distributed queries

optimizing performance, 6-2

drivers

ODBC, 7-12

OLE DB (FS), 7-15

OLE DB (SQL), 7-14

dynamic performance views

Heterogeneous Services, 4-25

determining open sessions, 4-26

determining which agents are on host, 4-26

E

EXECUTE_IMMEDIATE procedure, 3-7

restrictions, 3-7

EXECUTE_NON_QUERY procedure, 3-7

F

FDS_CLASS, 4-12

FDS_CLASS_VERSION, 4-12

FDS_INST_NAME, 4-13

FETCH_ROW procedure, 3-7

executing queries using pass-through SQL, 3-11

fetches

bulk, 4-7

optimizing round-trips, 3-12

G

gateways

how they work, 2-9

Generic Connectivity

architecture, 7-2

Oracle and non-Oracle on same machine, 7-4

Oracle and non-Oracle on separate machines, 7-3

configuration, 7-7

creating initialization file, 7-7

data dictionary

translation support, C-1

defined, 1-3

definition, 7-2

DELETE statement, 7-6

editing initialization file, 7-7

Heterogeneous Services, 2-4

INSERT statement, 7-6

non-Oracle data dictionary access, C-2

ODBC connectivity requirements, 7-12

OLE DB (FS) connectivity requirements, 7-15

OLE DB (SQL) connectivity requirements, 7-14

restrictions, 7-5

setting parameters for ODBC source, 7-9

UNIX, 7-10

Windows NT, 7-9

setting parameters for OLE DB source, 7-11

SQL execution, 7-5

supported functions, 7-6

supported SQL syntax, 7-6

types of agents, 7-2

UPDATE statement, 7-6

generic connectivity

error tracing, A-7

GET_VALUE procedure, 3-7, 3-10, 3-11

globalization support

Heterogeneous Services, A-7

character set of non-Oracle source, A-10

date format, A-9

languages in character date values, A-10

H

heterogeneous distributed systems

accessing, 4-2

Heterogeneous Services

agent control utility (agtctl), 5-7

agent registration, 4-10

avoiding configuration mismatches, 4-11

disabling, 4-14

enabling, 4-10

self-registration, 4-12

application development

controlling array fetches between non-Oracle server and agent, 4-9

controlling array fetches between Oracle server and agent, 4-9

controlling reblocking of array fetches, 4-9

DBMS_HS_PASSTHOUGH package, 3-5

pass-through SQL, 3-5

using bulk fetches, 4-7

using OCI for bulk fetches, 4-8

creating database links, 4-3

data dictionary views, 4-20, C-2

types, 4-20

understanding sources, 4-21

using general views, 4-22

using SQL service views, 4-24

using transaction service views, 4-23

defining maximum number of open cursors, A-12

dynamic performance views, 4-25

V$HS_AGENT view, 4-26

V$HS_SESSION view, 4-26

Generic Connectivity

architecture, 7-2

creating initialization file, 7-7

definition, 7-2

editing initialization file, 7-7

non-Oracle data dictionary access, C-2

ODBC connectivity requirements, 7-12

OLE DB (FS) connectivity requirements, 7-15

OLE DB (SQL) connectivity requirements, 7-14

restrictions, 7-5

setting parameters for ODBC source, 7-9

setting parameters for OLE DB source, 7-11

SQL execution, 7-5

supported functions, 7-6

supported SQL syntax, 7-6

supported tables, C-5

types of agents, 7-2

initialization parameters, 2-6, 4-5, 7-7, A-1

multithreaded agents, 5-1

optimizing data transfer, A-12

setting global name, A-5

setting up access using Transparent Gateway, 4-2

setting up environment, 4-2

specifying cache high water mark, A-5

specifying cache size, A-12

specifying commit point strength, A-3

SQL service, 2-5

testing connections, 4-4

transaction service, 2-4

tuning internal data buffering, A-13

tuning LONG data transfer, A-9

HS_AUTOREGISTER initialization parameter

using to enable agent self-registration, 4-14

HS_BASE_CAPS view, 4-20

HS_BASE_DD view, 4-20

HS_CALL_NAME initialization parameter, A-3

HS_CLASS_CAPS view, 4-21

HS_CLASS_DD view, 4-21

HS_CLASS_INIT view, 4-21

HS_COMMIT_POINT_STRENGTH initialization parameter, A-3

HS_DB_NAME initialization parameter, A-5

HS_DESCRIBE_CACHE_HWM initialization parameter, A-5

HS_FDS_CLASS view, 4-21

HS_FDS_CONNECT_INFO initialization parameter, A-5

specifying connection information, 7-8

HS_FDS_DEFAULT_SCHEMA_NAME initialization parameter, A-6

HS_FDS_FETCH_ROWS initialization parameter, 4-9

HS_FDS_INST view, 4-21

HS_FDS_SHAREABLE_NAME initialization parameter, A-7

HS_FDS_TRACE_LEVEL initialization parameter, A-7

enabling agent tracing, 7-8

HS_LANGUAGE initialization parameter, A-7

HS_LONG_PIECE_TRANSFER_SIZE initialization parameter, A-9

HS_NLS_DATE_FORMAT initialization parameter, A-9

HS_NLS_DATE_LANGUAGE initialization parameter, A-10

HS_NLS_NCHAR initialization parameter, A-10

HS_NLS_NUMERIC_CHARACTER initialization parameter, A-10

HS_NLS_TIMESTAMP_FORMAT initialization parameter, A-11

HS_NLS_TIMESTAMP_TZ_FORMAT initialization parameter, A-11

HS_OPEN_CURSORS initialization parameter, A-12

HS_ROWID_CACHE_SIZE initialization parameter, A-12

HS_RPC_FETCH_REBLOCKING initialization parameter, 4-9, A-12

HS_RPC_FETCH_SIZE initialization parameter, 4-9, A-13

HS_TIME_ZONE initialization parameter, A-14

I

IFILE initialization parameter, A-14

information integration

benefits of Oracle solutions, 1-4

challenges, 1-2

Generic Connectivity, 1-3

how Oracle addresses, 1-2

Messaging Gateway, 1-4

Open System Interfaces, 1-4

Oracle Streams, 1-4

Oracle Transparent Gateways, 1-3

initialization parameters

Heterogeneous Services (HS), 2-6, 4-5, 7-7, A-1

initialization parameters (HS)

common to all gateways, 4-5

descriptions, A-1

Generic Connectivity, 7-7

purpose, 2-6

L

listeners, 4-2

M

Messaging Gateway

defined, 1-4

monitor thread

multithreaded Heterogeneous Services agents, 5-3, 5-5

multiple rows

buffering, 3-12

multithreaded Heterogeneous Services agents

administering, 5-6

advantages, 5-2

agent control utility (agtctl), 5-7

architecture, 5-3

configuration parameters, 5-12

dispatcher threads, 5-3, 5-5

monitor thread, 5-3, 5-5

task threads, 5-3, 5-6

O

OCI

optimizing data transfers using, 4-8

ODBC agents

connectivity requirements, 7-12

functions, 7-12

ODBC connectivity

data dictionary mapping, C-5

ODBC driver, 7-12

requirements, 7-12

specifying connection information

UNIX, A-6

Windows NT, A-6

specifying path to library, A-7

OLE DB (FS) drivers, 7-15

OLE DB (SQL) drivers, 7-14

OLE DB agents

connectivity requirements, 7-14, 7-15

OLE DB connectivity

data dictionary mapping, C-5

setting connection information, A-6

OLE DB drivers

data provider requirements, 7-15

initialization properties, 7-17

rowset properties, 7-17

Open System Interfaces

defined, 1-4

OPEN_CURSOR procedure, 3-6

Oracle database server

SQL construct processing, 4-14

Oracle Net Services listener, 2-3, 4-2

Oracle precompiler

optimizing data transfers using, 4-8

Oracle Streams

defined, 1-4

Oracle Transparent Gateways

defined, 1-3

optimizing SQL statements, 6-2

OUT bind variables, 3-10

P

PARSE procedure, 3-6

pass-through SQL

avoiding SQL interpretation, 3-5

executing statements, 3-6

non-queries, 3-7

queries, 3-11

with bind variables, 3-8

with IN bind variables, 3-9

with IN OUT bind variables, 3-11

with OUT bind variables, 3-10

implications of using, 3-6

overview, 3-5

restrictions, 3-6

Q

queries

pass-through SQL, 3-11

R

reblocking, 4-9

remote functions

referenced in SQL statements, A-3

rows

buffering multiple, 3-12

S

SELECT statement

accessing non-Oracle system, C-2

service names

specifying in database links, 4-3

SQL capabilities

data dictionary tables, 4-24

SQL service

data dictionary views, 2-8, 4-20

Heterogeneous Services, 2-5

views

Heterogeneous Services, 4-24

SQL statements

optimizing distributed, 6-2

Streams

using for heterogeneous connectivity, 3-3

Synonyms, 4-17

T

task threads

multithreaded Heterogeneous Services agents, 5-3, 5-6

transaction service

Heterogeneous Services, 2-4

views

Heterogeneous Services, 4-23

transparent gateways

accessing Heterogeneous Services agents, 4-2

creating database links, 4-3

testing connections, 4-4

U

unsupported functions

Generic Connectivity, 7-6

user-defined functions

executing on non-Oracle database, 4-15

V

V$HS_AGENT view

determining which agents are on host, 4-26

V$HS_PARAMETER view

listing HS parameters, 4-27

V$HS_SESSION view

determining open sessions, 4-26

variables

bind, 3-7