Configuring multiple parallel process groups
Taking the parallel concept one step further, we can not only add parallel process groups at the target, but also at the source. The diagram at the start of this chapter gives an overview configuration, showing multiple parallel processes from the Data Pumps on the source, feeding data to dedicated Replicat processes, where the data is "split" again into more parallel threads.
Based on the following diagram, we will be configuring multiple process groups from scratch for 1 Extract process to enhance transaction throughput and reduce lag times:
In the following configuration example, the source database name is OLTP and its source schema name is SRC. The target database name is OLAP and its target schema name is TGT.
Source system configuration
The following section specifies an example configuration for parallel data processing that will be used to leverage the performance of the GoldenGate data capture and routing process.