This illustration shows the details of the primary database ps1.example.com 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.example.com. The propagation propagates all changes except changes with a tag of '2'.
One propagation that propagates captured changes to ps3.example.com. The propagation propagates all changes except changes with a tag of '3'.
One propagation that propagates captured changes to ps4.example.com. The propagation propagates all changes except changes with a tag of '4'.
One apply process that applies changes from ps2.example.com. These changes have a tag of '2' in the redo log.
One apply process that applies changes from ps3.example.com. These changes have a tag of '3' in the redo log.
One apply process that applies changes from ps4.example.com. These changes have a tag of '4' in the redo log.
One propagation to propagate locally captured LCRs to mult2.example.com and another propagation to propagate locally captured LCRs to mult3.example.com.