While working on tuning a Goldengate replicate process I ran into something that would speed up slow migrations.
The redolog algorythm modifying parameters below can be used for more than just Goldengate.
When using Goldengate these would only be used during conversion on the 12c replicat side – and possibly at the session level.
Both of the following at the NON-default values to expedite processing / loads / migrations / replications. There are risks to recovery if a crash occurs while these parameters are set – corruption of the current redolog is possible. Therefore, I would only use these settings when I know that I can recover without current redologs – that would be very rare, like possibly during a migration.
Alter session | system set commit_wait=no_wait;Alter session | system set commit_logging=batch;
Using this feature allows us to increase the parallel load by generally making the writes faster and minimizing lock hold duration – good chance many processes would see a significant increase ability to process objects / data.
Obviously there are lots of other ways to tune Goldengate 12c. It appears the new release 12.2 at the time of this writing, does much of the tuning automatically in many cases… but not this one.
Here is a link to a good explanation of using the feature by Christian Antognini: