My Oracle Support Banner

Streams Synchronous Capture 11g New Feature Example (Doc ID 1109293.1)

Last updated on DECEMBER 18, 2023

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1 to 11.2]
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
Minimal patches that needs to be applied before configuring Streams Streams Specific Patches (Doc ID 437838.1)
10gR2 Streams Recommended Configuration (Doc ID 418755.1)


Streams Synchronous Capture is a New Feature of Oracle 11g; It doesn't rely on archive logs 
or redo logs to capture changes. Instead a synchronous capture uses an internal mechanism to 
capture changes and format each captured change into an LCR. The messages captured by a synchronous capture
are called persistent LCRs. A synchronous capture always enqueues into a commit-time queue
to ensure that transactions are ordered properly.

As a matter of fact, propagation and apply processes don't change so much.
Sync capture captures the DML change made using Insert update delete merger
It can be used even if the source database is running in noarchivelog mode and 
doesn't require you add any supplemental logging.
Use Synchronous capture when 
 Redo-based capture is not possible ( such as the Standards Edition on the database )
 Redo or logminer-related cannot be used but other streams background process can be utilized
 Capture need to occur at the same time ( Synchronous) to user transaction
 Change should be stored on a queue on disk ( persistently)
 Clone data of table with few updates
Data Types Captured by Synchronous Capture
When capturing the row changes resulting from DML changes made to tables,
synchronous capture can capture changes made to columns of the following data
More detail
Streams Concepts and Administration 11g Release 2 (11.2) E10704-05
Implicit Capture with Synchronous Capture
Synchronous Capture  Rules
A synchronous capture table rule with a positive rule set,
A synchronous capture cannot have a negative rule set.
A synchronous capture cannot use schema rules 
A synchronous capture cannot use global rules.
Note: You cannot use ADD_SCHEMA_RULES or ADD_GLOBAL_RULES to create synchronous


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.