O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring Change Delivery

Change Delivery is the process of applying the transactions that contain the data changes from the source database to the target database. As we know, this is the responsibility of the Replicat process. The Replicat extracts the pure DML and DDL from the remote trail files and applies them on the target database. This process can often cause a bottleneck, depending on the volume of data being replicated. Oracle recommends multiple Replicats to enable parallel processing to enhance performance.

For this example, we shall create just one Replicat named ROLAP01.

Before we create and configure our Replicat process, we must first create a Checkpoint table in the target database. The Checkpoint table keeps track of all the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required