Master-to-Slave/Single-Source

A configuration of Oracle Streams where there is one Source and one Target.

MEMORY_MAX_TARGET *

Specifies the maximum value to which a DBA can set the MEMORY_TARGET initialization parameter.

MEMORY_TARGET *

Specifies the Oracle system-wide usable memory.

N-Way Replication

Refer to Master-to-Master/Multi-Source.

OPEN_LINKS *

Specifies the maximum number of concurrent open connections to remote databases in one session.

Oracle Data Guard

An Oracle product specifically for High Availablity. This product handles failover in a gracious manner.

PROCESSES *

Specifies the maximum number of operating system user processes that can simultaneously connect to Oracle.

Propagation (Process)

The Streams process that sends LCRs from Source to Target across a Database Link.

QUEUE

Staging area in both memory and/or tables that contain messages and/or LCRs.

Replication

As related to Streams, the sharing data across multiple database.

Rule(s)

Are used to determine how message and/or LCR are handled.

SCN

System Change Number.

SHARED_POOL_SIZE *

Specifies (in bytes) the size of the shared pool.

Slave Site

The Target site where LCRs are applied.

SPFILE

The dynamic parameter file of the Oracle database.

STREAMS_POOL_SIZE *

Synchronous

Processes that are blocking. With reference to Streams there are Asynchronous actions related to configuring LOG_ARCHIVE_DEST_N of Downstreams Capture.

Tag(s)

An identifier that relates to a LCR. Tags can be evaluted by Rules to determine how the LCR is to be handled.

TIMED_STATISTICS

Oracle parameter that is recommended to be set to TRUE. This allows for collection of time statistics.

Two phase commit

A commit or rollback of a transaction. An all-commit or all-rollback situation.

UNDO_RETENTION *

Oracle parameter that specifies (in seconds) the low threshold value of undo retention.

Unidirectional

Related to Streams configuration, from a Master Site to Slave Site.

WAN

Wide Area Network.