Oracle8i Distributed Database Systems -- Index

abort response, 4-13

two-phase commit, 4-13

administration

distributed databases, 2-1

tools, 1-31

agents

generic connectivity, 6-6

Heterogeneous Services, 6-3, 6-5

definition, 1-5

disabling self-registration, 7-9

registering, 7-5, 7-6, 7-7

specifying initialization parameters for, 7-4

aggregate functions, 2-33

ALL_DB_LINKS view, 2-21

ALTER SESSION

system privilege, 3-2

ALTER SESSION statement

ADVISE clause, 5-13

CLOSE DATABASE LINK clause, 3-2

ALTER SYSTEM statement

DISABLE DISTRIBUTED RECOVERY clause, 5-28

ENABLE DISTRIBUTED RECOVERY clause, 5-28

ANALYZE TABLE statement, 3-7

analyzing tables

cost-based optimization, 3-7

application development

constraints, 3-3

database links

controlling connections, 3-2

distributed databases, 3-1

analyzing execution plan, 3-10

controlling connections, 3-2

handling errors, 3-3

handling RPC errors, 3-12

managing distribution of data, 3-2

managing referential integrity, 3-3

optimizing distributed queries, 1-47

overview, 1-44

remote procedure calls, 1-46

tuning distributed queries, 3-3

tuning using collocated inline views, 3-4

using cost-based optimization, 3-5

using hints to tune queries, 3-8

distributing data, 3-2

Heterogeneous Services, 9-1, 9-2

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

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

controlling reblocking of array fetches, 9-11

DBMS_HS_PASSTHROUGH package, 9-2

pass-through SQL, 9-2

using bulk fetches, 9-9

using OCI for bulk fetches, 9-10

referential integrity, 3-3

remote connections

terminating, 3-2

using Heterogeneous Services, 9-1

applications

errors

RAISE_APPLICATION_ERROR() procedure, 3-12

array fetches, 9-10

agents, 9-11

auditing

database links, 1-31

AUTHENTICATED BY clause

CREATE DATABASE LINK statement, 2-16

authentication

database links, 1-25

bind queries

executing using pass-through SQL, 9-7

BIND_INOUT_VARIABLE procedure, 9-3, 9-7

BIND_OUT_VARIABLE procedure, 9-3, 9-6

BIND_VARIABLE procedure, 9-3

buffers

multiple rows, 9-8

bulk fetches

optimizing data transfers using, 9-9

calls

remote procedure, 1-46

CATHO.SQL script

installing data dictionary for Heterogeneous Services, 7-2

centralized user management

distributed systems, 1-27

character sets

Heterogeneous Services, A-6

client/server architectures

distributed databases, 1-7

direct and indirect connections, 1-9

NLS, 1-47

CLOSE DATABASE LINK clause

ALTER SESSION statement, 3-2

CLOSE_CURSOR function, 9-3

closing database links, 2-18

collocated inline views

tuning distributed queries, 3-4

comments

in COMMIT statements, 5-13

commit phase, 4-12, 4-24

two-phase commit, 4-14

commit point site, 4-7

commit point strength, 4-9, 5-5, A-2

determining, 4-10

distributed transactions, 4-7, 4-9

how Oracle determines, 4-9

commit point strength

definition, 4-9

specifying, 5-5

COMMIT statement

COMMENT parameter, 5-13, 5-26

FORCE clause, 5-13, 5-14, 5-15

forcing, 5-12

two-phase commit and, 1-36

COMMIT_POINT_STRENGTH initialization parameter, 4-9, 5-6

committing transactions

distributed

commit point site, 4-7

configuring generic connectivity, 8-6

configuring transparent gateways, 7-2

connected user database links, 2-12

advantages and disadvantages, 1-17

creating, 2-12

definition, 1-17

example, 1-20

REMOTE_OS_AUTHENT initialization parameter, 1-18

connection qualifiers

database links and, 2-13

connections

remote

terminating, 3-2

constraints

application development issues, 3-3

ORA-02055

constrain violation, 3-3

cost-based optimization, 3-5

distributed databases, 1-47

hints, 3-8

using for distributed queries, 3-5

CREATE DATABASE LINK statement, 2-9

CREATE_INST_INIT procedure, 7-18

creating connected user links

scenario, 2-36

creating current user links

scenario, 2-37

creating database links, 2-8

service names within link names, 2-13

specifying types, 2-9

creating fixed user links

scenario, 2-34, 2-35

current user database links, 2-12

advantages and disadvantages, 1-19

cannot access in shared schema, 1-28

creating, 2-12

definition, 1-17

example, 1-20

schema independence, 1-28

cursors

and closing database links, 3-2

data dictionary

contents with generic connectivity, C-3

installing for Heterogeneous Services, 7-2

mapping for generic connectivity, C-4

Oracle server name/SQL Server name, C-4

purging pending rows from, 5-15, 5-16

tables, 6-4

translation support for generic connectivity, C-2

data dictionary views

DBA_DB_LINKS, 2-21, 5-6, 5-9

generic connectivity, C-3

Heterogeneous Services, 7-9, B-1

USER, 5-6, 5-9

data encryption

distributed systems, 1-30

data manipulation language

statements allowed in distributed transactions, 1-33

database links

advantages, 1-13

auditing, 1-31

authentication, 1-25

without passwords, 1-26

closing, 2-18, 3-2

connected user, 2-12, 2-36

advantages and disadvantages, 1-17

definition, 1-17

connections

controlling, 3-2

determining open, 2-24

creating, 2-8

connected user, 2-12, 2-36

connected user, shared, 2-36

current user, 2-12, 2-37

example, 1-20

fixed user, 2-11, 2-34

fixed user, shared, 2-35

obtaining necessary privileges, 2-8

specifying types, 2-9

current user, 1-16, 2-12

advantages and disadvantages, 1-19

definition, 1-17

data dictionary views

ALL, 5-6, 5-9

DBA_DB_LINKS, 5-6, 5-9

USER, 2-21, 5-6, 5-9

definition, 1-10

distributed queries, 1-34

distributed transactions, 1-35

dropping, 2-19

enforcing global naming, 2-3

enterprise users and, 1-28

fixed user, 2-34

advantages and disadvantages, 1-18

definition, 1-17

global

definition, 1-16

global names, 1-13

global object names, 1-36

handling errors, 3-3

heterogeneous systems, 6-2, 7-4

limiting number of connections, 2-20

listing, 2-21, 5-6, 5-9

managing, 2-18

minimizing network connections, 2-14

name resolution, 1-36

schema objects, 1-38

views, synonyms, and procedures, 1-41

when global database name is complete, 1-37

when global database name is partial, 1-37

when no global database name is specified, 1-37

passwords

private

public

referential integrity in, 3-3

remote queries, 1-33

remote transactions, 1-33, 1-35

resolution, 1-36

restrictions, 1-23

roles on remote database, 1-23

schema objects, 1-21

name resolution, 1-22

synonyms for, 1-22

service names used within link names, 2-13

shared, 1-12

configuring, 2-16

creating, 2-14

creating links to dedicated servers, 2-16

creating links to multi-threaded (MTS) servers, 2-17

determining whether to use, 2-14

shared SQL, 1-34

tuning distributed queries, 3-3

tuning queries with hints, 3-8

tuning using collocated inline views, 3-4

types of links, 1-16

types of users, 1-17

users

specifying, 2-11

using cost-based optimization, 3-5

viewing, 2-21

databases

administration, 2-1

distributed

site autonomy of, 1-24

datatypes

mapping, 6-4

ODBC, D-2

ODBC to Oracle, D-2

OLE DB, D-3

OLE DB to Oracle, D-3

date formats

Heterogeneous Services, A-7

DBA_2PC_NEIGHBORS view, 5-9

using to trace session tree, 5-9

DBA_2PC_PENDING view, 5-6, 5-15, 5-25

using to list in-doubt transactions, 5-7

DBA_DB_LINKS view, 2-21, 5-6, 5-9

DBMS_HS package

specifying HS parameters, 7-17

DBMS_HS_PASSTHROUGH package, 9-2

list of functions and procedures, 9-3

DBMS_TRANSACTION package

PURGE_LOST_DB_ENTRY procedure, 5-16

declarative referential integrity constraints, 3-3

describe cache high water mark

definition, A-3

Digital's POLYCENTER Manager on NetView, 1-32

disabling recoverer process

distributed transactions, 5-28

distributed applications

distributing data, 3-2

distributed databases

administration

overview, 1-23

application development

analyzing execution plan, 3-10

controlling connections, 3-2

handling errors, 3-3

handling RPC errors, 3-12

managing distribution of data, 3-2

managing referential integrity, 3-3

tuning distributed queries, 3-3

tuning using collocated inline views, 3-4

using cost-based optimization, 3-5

using hints to tune queries, 3-8

client/server architectures, 1-7

commit point strength, 4-9

cost-based optimization, 1-47

distributed processing, 1-3

distributed queries, 1-34

distributed updates, 1-34

distributing an application's data, 3-2

global database names

how they are formed, 2-2

global object names, 1-22, 2-2

global users

schema-dependent, 1-27

schema-independent, 1-28

location transparency, 1-44

creating, 2-26

creating using procedures, 2-30

creating using synonyms, 2-28

creating using views, 2-26

restrictions, 2-33

management tools, 1-31

managing read consistency, 5-28

NLS support, 1-47

nodes of, 1-7

overview, 1-2

referential integrity

application development, 3-3

remote object security, 2-28

remote queries and updates, 1-33

replicated databases and, 1-4

scenarios, 2-34

security, 1-25

site autonomy, 1-24

SQL transparency, 1-45

testing features, 5-26

transaction processing, 1-33

transparency, 1-44

queries, 2-32

updates, 2-32

distributed processing

distributed databases, 1-3

distributed queries, 1-34

analyzing tables, 3-7

application development issues, 3-3

cost-based optimization, 3-5

optimizing, 1-47

distributed systems

data encryption, 1-30

distributed transactions, 1-35

case study, 4-20

commit point site, 4-7

commit point strength, 4-9

committing, 4-9

database server role, 4-6

decreasing limit for, 5-3

defined, 4-2

disabling processing of, 5-3

DML and DDL, 4-3

failure during, 5-4

forcing to fail, 5-26

global coordinator, 4-7

increasing limit for, 5-3

initialization parameters influencing, 5-2

limiting number, 5-2

local coordinator, 4-7

lock timeout interval, 5-4

locked resources, 5-4

locks for in-doubt, 5-5

management, 4-1, 5-1

manually overriding in-doubt, 5-12

recovery in single-process systems, 5-28

session trees, 4-4, 4-5, 4-6

clients, 4-6

commit point site, 4-7, 4-9

database servers, 4-6

global coordinators, 4-7

local coordinators, 4-6

setting advice, 5-13

specifying

commit point strength, 5-5

interval for open connections, 5-5

tracing session tree, 5-9

transaction control statements, 4-4

transaction timeouts, 5-4

two-phase commit, 4-4

discovering problems, 5-11

example, 4-20

viewing information about, 5-6

distributed updates, 1-34

DISTRIBUTED_LOCK_TIMEOUT initialization parameter

controlling time-outs with, 5-4

DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME initialization parameter, 5-5

DISTRIBUTED_TRANSACTIONS initialization parameter

recoverer process (RECO), 5-3

setting, 5-2

when to alter, 5-3

DML. See data manipulation language

drivers

ODBC, 8-12

OLEFS, 8-15

OLESQL, 8-14

DRIVING_SITE hint, 3-9

dropping database links, 2-19

dynamic performance views

Heterogeneous Services, 7-15

determining open sessions, 7-16

determining which agents are on host, 7-15

enabling recoverer process

distributed transactions, 5-28

enterprise users

definition, 1-28

errors

messages

ORA-02055

integrity constrain violation, 3-3

ORA-02067

rollback required, 3-3

ORA-06510

PL/SQL error, 3-13

remote procedures, 3-12

examples

manual transaction override, 5-17

exception handler, 3-12

local, 3-13

EXCEPTION keyword, 3-12

exceptions

assigning names

PRAGMA_EXCEPTION_INIT, 3-12

user-defined

PL/SQL, 3-12

EXECUTE_IMMEDIATE procedure, 9-3

restrictions, 9-4

EXECUTE_NON_QUERY procedure, 9-3

execution plans

analyzing for distributed queries, 3-10

FDS_CLASS, 7-7

FDS_CLASS_VERSION, 7-7

FDS_INST_NAME, 7-8

features, new

centralized user and privilege management, xiv

generic connectivity, xiii

Heterogeneous Services initialization parameters, xiv

parallel DML and DDL, xiv

SQL optimization for heterogeneous systems, xiv

V$HS_AGENT and V$HS_SESSION, xv

FETCH_ROW procedure, 9-3

executing queries using pass-through SQL, 9-7

fetches

bulk, 9-9

optimizing round-trips, 9-8

fixed user database links

07_DICTIONARY_ACCESSIBILITY initialization parameter, 1-18

advantages and disadvantages, 1-18

creating, 2-11

definition, 1-17

example, 1-20

FORCE clause

COMMIT statement, 5-13

ROLLBACK statement, 5-13

forcing

COMMIT or ROLLBACK, 5-8, 5-12

forget phase

two-phase commit, 4-16

generic connectivity

architecture, 8-3

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

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

configuration, 8-6

creating initialization file, 8-7

data dictionary

translation support, C-2

datatype mapping, 8-5

definition, 1-6, 8-2

DELETE statement, 8-6

editing initialization file, 8-7

error tracing, A-5

Heterogeneous Services, 6-6

INSERT statement, 8-6

non-Oracle data dictionary access, C-2

ODBC connectivity requirements, 8-12

OLE DB (FS) connectivity requirements, 8-15

interfaces, 8-16

OLE DB (SQL) connectivity requirements, 8-14

restrictions, 8-5

setting parameters for ODBC source, 8-9

UNIX, 8-10

Windows NT, 8-9

setting parameters for OLE DB source, 8-11

SQL execution, 8-5

supported functions, 8-6

supported SQL syntax, 8-5

types of agents, 8-2

UPDATE statement, 8-6

GET_VALUE procedure, 9-3, 9-6, 9-7

global coordinators, 4-7

distributed transactions, 4-7

global database consistency

distributed databases and, 4-15

global database links, 1-16

creating, 2-11

global database names

changing the domain, 2-4

database links, 1-13

distributed databases

how they are formed, 2-2

enforcing for database links, 1-15

enforcing global naming, 2-3

impact of changing, 1-42

querying, 2-4

global object names

database links, 1-36

distributed databases, 2-2

global users, 2-37

distributed systems

schema-dependent, 1-27

schema-independent, 1-28

GLOBAL_NAME view

using to determine global database name, 2-4

GLOBAL_NAMES initialization parameter, 1-15

GV$DBLINK view, 2-24

heterogeneous distributed systems

accessing, 7-2

definition, 1-5

Heterogeneous Services

agent registration, 7-5

avoiding configuration mismatches, 7-6

disabling, 7-9

enabling, 7-5

agents, 6-3, 6-5

self-registration, 7-7

application development, 9-1, 9-2

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

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

controlling reblocking of array fetches, 9-11

DBMS_HS_PASSTHOUGH package, 9-2

locking behavior of non-Oracle systems, 9-12

pass-through SQL, 9-2

using bulk fetches, 9-9

using OCI for bulk fetches, 9-10

creating database links, 7-4

data dictionary, 6-6

classes and instances, 6-7

data dictionary views, 7-9, B-1

types, 7-9

understanding sources, 7-11

using general views, 7-11

using SQL service views, 7-13

using transaction service views, 7-12

database links to non-Oracle systems, 6-2

DBMS_HS package

using to specify initialization parameters, 7-17

using to unspecify initialization parameters, 7-18

defining maximum number of open cursors, A-8

dynamic performance views, 7-15

V$HS_AGENT view, 7-15

V$HS_SESSION view, 7-16

features, 1-6

generic connectivity

architecture, 8-3

creating initialization file, 8-7

datatype mapping, 8-5

definition, 8-2

editing initialization file, 8-7

non-Oracle data dictionary access, C-2

ODBC connectivity requirements, 8-12

OLE DB (FS) connectivity requirements, 8-15

OLE DB (FS) interfaces, 8-16

OLE DB (SQL) connectivity requirements, 8-14

restrictions, 8-5

setting parameters for ODBC source, 8-9

setting parameters for OLE DB source, 8-11

SQL execution, 8-5

supported functions, 8-6

supported SQL syntax, 8-5

supported tables, C-3

types of agents, 8-2

initialization parameters

specifying, 7-17

unspecifying, 7-18

installing data dictionary, 7-2

locking behavior of non-Oracle systems, 9-12

optimizing data transfer, A-9

overview, 1-5, 6-2

process architecture, 6-4, 6-5

setting global name, A-3

setting up access using transparent gateway, 7-2

setting up environment, 7-2

specifying cache high water mark, A-3

specifying cache size, A-9

specifying commit point strength, A-2

specifying domain, A-2

specifying instance identifier, A-3

SQL service, 6-4

testing connections, 7-4

transaction service, 6-3

tuning internal data buffering, A-10

types, 6-3

hints, 3-8

DRIVING_SITE, 3-9

NO_MERGE, 3-9

using to tune distributed queries, 3-8

HP's OpenView, 1-32

HS_AUTOREGISTER initialization parameter, 7-17

using to enable agent self-registration, 7-8

HS_BASE_CAPS view, 7-10

HS_BASE_DD view, 7-10

HS_CLASS_CAPS view, 7-10

HS_CLASS_DD view, 7-10

HS_CLASS_INIT view, 7-10

HS_COMMIT_POINT_STRENGTH initialization parameter, A-2

HS_DB_DOMAIN initialization parameter, 7-18, A-2

HS_DB_INTERNAL_NAME initialization parameter, A-3

HS_DB_NAME initialization parameter, A-3

HS_DESCRIBE_CACHE_HWM initialization parameter, A-3

HS_FDS_CLASS view, 7-10

HS_FDS_CONNECT_INFO initialization parameter, A-4

specifying connection information, 8-7

HS_FDS_FETCH_ROWS initialization parameter, 9-11

HS_FDS_INST view, 7-10

HS_FDS_SHAREABLE_NAME initialization parameter, A-5

HS_FDS_TRACE initialization parameter, A-5

HS_FDS_TRACE_FILE_NAME initialization parameter, A-5

HS_FDS_TRACE_LEVEL initialization parameter

enabling agent tracing, 8-8

HS_INST_CAPS view, 7-10

HS_INST_DD view, 7-10

HS_INST_INIT view, 7-10

HS_LANGUAGE initialization parameter, A-6

HS_NLS_DATE_FORMAT initialization parameter, A-7

HS_NLS_DATE_LANGUAGE initialization parameter, A-7

HS_NLS_NCHAR initialization parameter, A-8

HS_OPEN_CURSORS initialization parameter, A-8

HS_ROWID_CACHE_SIZE initialization parameter, A-9

HS_RPC_FETCH_REBLOCKING initialization parameter, 9-11, A-9

HS_RPC_FETCH_SIZE initialization parameter, 9-11, A-10

IBM's NetView/6000, 1-32

in-doubt transactions, 4-14

integrity constraints

ORA-02055

constraint violation, 3-3

joins

distributed databases

managing statement transparency, 2-33

listeners, 7-2

listing database links, 2-21, 5-6, 5-9

local coordinators, 4-7

distributed transactions, 4-6

location transparency

distributed databases

creating using procedures, 2-30

creating using synonyms, 2-28

creating using views, 2-26

using procedures, 2-30, 2-31, 2-32

lock timeout interval

distributed transactions, 5-4

locks

in distributed transactions, 5-4

in non-Oracle systems, 9-12

in-doubt distributed transactions, 5-4, 5-5

LONG columns, 2-33

LONG RAW columns, 2-33

manual overrides

in-doubt transactions, 5-13

messages

error

trapping, 3-12

multiple rows

buffering, 9-8

name resolution

distributed databases, 1-22

impact of global name changes, 1-42

schema objects, 1-38

when global database name is complete, 1-37

when global database name is partial, 1-37

when no global database name is specified, 1-37

National Language Support (NLS)

client/server architectures, 1-48

distributed databases

clients and servers may diverge, 1-47

heterogeneous systems, 1-49

homogeneous systems, 1-48

Heterogeneous Services, A-6

character set of non-Oracle source, A-8

date format, A-7

languages in character date values, A-7

Net8 listener, 6-5, 7-2

network connections

minimizing, 2-14

networks

distributed databases use of, 1-2

new features

centralized user and privilege management, xiv

generic connectivity, xiii

Heterogeneous Services initialization parameters, xiv

parallel DML and DDL, xiv

SQL optimization for heterogeneous systems, xiv

V$HS_AGENT and V$HS_SESSION, xv

NO_DATA_FOUND keyword, 3-12

NO_MERGE hint, 3-9

Novell's NetWare Management System, 1-32

objects

referencing with synonyms, 2-29

OCI

optimizing data transfers using, 9-10

ODBC agents

connectivity requirements, 8-12

functions, 8-12

ODBC connectivity

data dictionary mapping, C-4

mapping OBDC datatypes, D-2

mapping Oracle datatypes, D-2

ODBC driver, 8-12

requirements, 8-12

specifying connection information

UNIX, A-4

Windows NT, A-4

specifying path to library, A-5

OLE DB agents

connectivity requirements, 8-14, 8-15

interfaces, 8-16

OLE DB connectivity

data dictionary mapping, C-4

mapping to Oracle datatypes, D-3

setting connection information, A-4

OLEFS drivers, 8-15

data provider requirements, 8-15

initialization properties, 8-17

rowset properties, 8-17

security, 8-15

OLESQL drivers, 8-14

data provider requirements, 8-14

security, 8-14

OPEN_CURSOR procedure, 9-3

OPEN_LINKS initialization parameter, 2-20

ORA-00900 error, 3-12

ORA-02015 error, 3-12

ORA-02055 error

integrity constraint violation, 3-3

ORA-02067 error

rollback required, 3-3

ORA-06510 error

PL/SQL error, 3-13

Oracle Call Interface. See OCI

Oracle precompiler

optimizing data transfers using, 9-10

Oracle Transparent Gateways

Heterogeneous Services and, 6-3

OUT bind variables, 9-6

PARSE procedure, 9-3

pass-through SQL, 9-2

avoiding SQL interpretation, 9-2

executing statements, 9-3

non-queries, 9-4

queries, 9-7

with bind variables, 9-4

with IN bind variables, 9-5

with IN OUT bind variables, 9-6

with OUT bind variables, 9-6

implications of using, 9-3

overview, 9-2

restrictions, 9-3

passwords

database links

viewing, 2-22

pending transaction tables, 5-25

PL/SQL

development environment, 9-2

errors

ORA-06510, 3-13

user-defined exceptions, 3-12

PRAGMA_EXCEPTION_INIT procedure

assigning exception names, 3-12

prepare phase, 4-12

recognizing read-only nodes, 4-13

two-phase commit, 4-11, 4-12

prepare/commit phases

abort response, 4-12

effects of failure, 5-4

failures during, 5-11

forcing to fail, 5-26

locked resources, 5-4

pending transaction table, 5-25

prepared response, 4-12

read-only response, 4-12

testing recovery, 5-26

prepared response

two-phase commit, 4-12

private database links, 1-16

privileges

closing a database link, 3-2

creating database links, 2-8

managing with procedures, 2-32

managing with synonyms, 2-30

managing with views, 2-28

procedures

location transparency using, 2-30, 2-31, 2-32

remote calls, 1-46

process architecture for distributed external procedures, 6-6

public database links

connected user, 2-36

fixed user, 2-34

public fixed user database links, 2-34

PURGE_LOST_DB_ENTRY procedure

DBMS_TRANSACTION package, 5-16

purging pending rows

from data dictionary, 5-15

when necessary, 5-16

queries

distributed, 1-34

application development issues, 3-3

distributed or remote, 1-33

location transparency and, 1-45

pass-through SQL, 9-7

post-processing, 3-4

remote, 3-4

transparency, 2-32

read consistency

managing in distributed databases, 5-28

read-only response

two-phase commit, 4-12

reblocking, 9-11

recoverer process (RECO)

disabling, 5-27, 5-28

distributed transaction recovery, 5-27

DISTRIBUTED_TRANSACTIONS initialization parameter, 5-3

enabling, 5-27, 5-28

pending transaction table, 5-27

recovery

testing distributed transactions, 5-26

referential integrity

distributed database systems

application development, 3-3

remote data

querying, 2-33

updating, 2-33

remote procedure calls, 1-46

distributed databases and, 1-46

remote queries, 3-4

distributed databases and, 1-33

execution, 3-4

post-processing, 3-4

remote transactions, 1-35

defined, 1-35

REMOTE_OS_AUTHENT initialization parameter, 1-18

roles

obtained through database links, 1-23

rollback segments

in-doubt distributed transactions, 5-12

ROLLBACK statement

FORCE clause, 5-13, 5-14, 5-15

forcing, 5-12

rollbacks

ORA-02067 error, 3-3

rows

buffering multiple, 9-8

savepoints

in-doubt transactions, 5-13, 5-15

schema objects

distributed database naming conventions for, 1-22

global names, 1-22

security, 8-15

distributed databases, 1-25

centralized user management, 1-27

OLESQL driver, 8-14

remote objects, 2-28

using synonyms, 2-30

SELECT statement

accessing non-Oracle system, C-2

FOR UPDATE clause, 2-33

SERVER parameter

net service name, 2-16

servers

role in two-phase commit, 4-6

service names

database links and, 2-13

specifying in database links, 7-4

session trees

distributed transactions, 4-4, 4-5

clients, 4-6

commit point site, 4-7, 4-9

database servers, 4-6

global coordinators, 4-7

local coordinators, 4-6

tracing, 5-9

sessions

setting advice for transactions, 5-13

shared database links

configuring, 2-16

creating links, 2-14, 2-15

to dedicated servers, 2-16

to multi-threaded (MTS) servers, 2-17

determining whether to use, 2-14

example, 1-20

SHARED keyword

CREATE DATABASE LINK statement, 2-15

shared SQL

for remote and distributed statements, 1-34

Simple Network Management Protocol (SNMP) support

database management, 1-32

single-process systems

enabling distributed recovery, 5-28

site autonomy

distributed databases, 1-24

SQL capabilities

data dictionary tables, 7-14

SQL dialect

understood by non-Oracle system, 6-4

SQL errors

ORA-00900, 3-12

ORA-02015, 3-12

SQL service

capabilities, 6-4

data dictionary views, 6-8, 7-10

Heterogeneous Services, 6-4

views

Heterogeneous Services, 7-13

SQL statements

distributed databases and, 1-33

mapping to non-Oracle datastores, 9-2

stored procedures

distributed query creation, 3-3

managing privileges, 2-32

remote object security, 2-32

subqueries, 2-33

in remote updates, 1-34

SunSoft's SunNet Manager, 1-33

synonyms

CREATE statement, 2-29

definition and creation, 2-29

examples, 2-29

location transparency using, 2-28

managing privileges, 2-30

name resolution, 1-41

name resolution in distributed databases, 1-41

remote object security, 2-30

system change numbers (SCN)

coordination in a distributed database system, 4-15

in-doubt transactions, 5-14

transaction control statements

distributed transactions and, 4-4

transaction failures

simulating, 5-26

transaction management

overview, 4-11

transaction processing

distributed systems, 1-33

transaction service

Heterogeneous Services, 6-3

views

Heterogeneous Services, 7-12

transactions

closing database links, 3-2

distributed

two-phase commit and, 1-36

in-doubt, 4-14

after a system failure, 5-11

pending transactions table, 5-25

recoverer process (RECO) and, 5-27

manually overriding in-doubt, 5-12

remote, 1-35

transparency

location

using procedures, 2-30, 2-31, 2-32

query, 2-32

update, 2-32

transparent gateways

accessing Heterogeneous Services agents, 7-2

creating database links, 7-4

Heterogeneous Services, 6-5

installing Heterogeneous Services data dictionary, 7-2

testing connections, 7-4

triggers

distributed query creation, 3-3

tuning

analyzing tables, 3-7

cost-based optimization, 3-5

two-phase commit

unsupported functions

generic connectivity, 8-6

updates

location transparency and, 1-45

transparency, 2-32

USER_DB_LINKS view, 2-21

V$DBLINK view, 2-24

V$HS_AGENT view

determining which agents are on host, 7-15

V$HS_PARAMETER view

listing HS parameters, 7-17

V$HS_SESSION view

determining open sessions, 7-16

variables

BIND, 9-4

views

location transparency using, 2-26

managing privileges with, 2-28

name resolution in distributed databases, 1-41

remote object security, 2-28

Index

A

B

C

D

E

F

G

H

I

J

L

M

N

O

P

Q

R

S

T

U

V