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.