Making the Instantiation Procedure More Efficient

Share Parameters Between Process Groups

The following are some suggestions to make the instantiation process more efficient.

Some of the parameters that you use in a change-synchronization parameter file also are required in an initial-load Extract and initial-load Replicat parameter file. To take advantage of the commonalities, you can use any of the following methods:

  • Copy common parameters from one parameter file to another.

  • Store the common parameters in a central file and use the OBEY parameter in each parameter file to retrieve them.

  • Create an Oracle GoldenGate macro for the common parameters and then call the macro from each parameter file with the MACRO parameter.

Use Parallel Processes

You can configure parallel initial-load processes to perform the initial load more quickly. It is important to keep tables with foreign-key relationships within the same set of processes. You can isolate large tables from smaller ones by using different sets of processes, or simply apportion the load across any number of process sets.