O'Reilly logo

Instant Oracle GoldenGate by Tony Bruzzese

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

Performance tuning (Simple)

In this last installment we'll examine some of the aspects that may help you to derive better throughput in your OGG processing.

How to do it…

One of the challenges of performance tuning is in deciding which component of Oracle GoldenGate environment needs tuning. In the following section you'll find a number of tips in order to improve OGG processing:

  1. When source and target have identical data structures and character set, add the following to your extract or data pump:
    PASSTHRU
    
  2. To scale up similar DML activity in your Replicat processes when the applier is underperforming, add the following keyword in your replicat parameter file:
    BATCHSQL
    
  3. Speeding up Replicat processing since we don't wait for the commit marker is done ...

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