1. Index

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 1
    • 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 1
      • 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 1
      • 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 1
      • types 1
      • understanding sources 1
      • using general views 1
      • using SQL service views 1
      • using transaction service views 1
    • dynamic performance views 1
      • 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 GoldenGate 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 GoldenGate
    • defined 1
    • using for heterogeneous connectivity 1
  • Oracle Net Services listener 1
  • Oracle precompiler
    • optimizing data transfers using 1
  • OUT bind variables 1

P

  • passthrough SQL
    • avoiding SQL interpretation 1
    • executing statements 1
      • 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
  • SQL statements
    • optimizing distributed 1
  • Synonyms 1

T

  • transaction service
    • Heterogeneous Services 1

U

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

V

  • variables
    • bind 1
  • views
    • data dictionary views 1
    • Heterogeneous Services 1
      • transaction service views 1