This illustration shows the details of the primary database ps1.net
Oracle Streams configuration, including the following mechanisms:
One queue that is used by the capture process, propagations, and apply processes.
A capture process that captures changes in the redo log and converts relevant changes into LCRs, which it enqueues. The capture process captures a change regardless of whether its tag is NULL
.
One propagation that propagates captured changes to ps2.net
. The propagation propagates all changes except changes with a tag of '2'
.
One propagation that propagates captured changes to ps3.net
. The propagation propagates all changes except changes with a tag of '3'
.
One propagation that propagates captured changes to ps4.net
. The propagation propagates all changes except changes with a tag of '4'
.
One apply process that applies changes from ps2.net
. These changes have a tag of '2'
in the redo log.
One apply process that applies changes from ps3.net
. These changes have a tag of '3'
in the redo log.
One apply process that applies changes from ps4.net
. These changes have a tag of '4'
in the redo log.
One propagation to propagate locally captured LCRs to mult2.net
and another propagation to propagate locally captured LCRs to mult3.net
.