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_INOUT_VARIABLE procedure 3.3.3.1.4
• BIND_OUT_VARIABLE procedure 3.3.3.1.3
• bind queries
  • executing using passthrough SQL 3.3.3.2
• buffers
  • multiple rows 3.3.3.2
• bulk fetches
  • optimizing data transfers using 4.2

---

C

• callback link 3.10.2
• 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
• 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
  • restrictions 3.3.3.1

---

F

• FDS_CLASS 4.4.1.2.1
• FDS_CLASS_VERSION 4.4.1.2.1
• FDS_INST_NAME 4.4.1.2.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.1.3

---

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

---

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 GoldenGate 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
• 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 GoldenGate
  • defined 1.2
  • using for heterogeneous connectivity 3.2
• Oracle Net Services listener 2.2
• Oracle precompiler
  • optimizing data transfers using 4.2.1
• OUT bind variables 3.3.3.1.3

---

P

• 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
• SQL statements
  • optimizing distributed 5.1
• Synonyms 4.7

---

T

• transaction service
  • Heterogeneous Services 2.4.1

---

U

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

---

V

• variables
  • bind 3.3.3.1.1
• views
  • data dictionary views 4.10.5
  • Heterogeneous Services 4.10.5
    • transaction service views 4.10.4