The following sections describe the Data Synchronization requirements for Oracle and Oracle parameter settings in the init.ora
file:
You should set the following parameters in the file init.ora
as given below:
Table C-1 lists parameters that must be set in the file init.ora
:
Check values for processes and DML_LOCKS
. Massive concurrent synchronization processes use the maximum amount of resources. For each one of the concurrent clients, Data Synchronization requires one database connection (one session, one transaction). Therefore, the parameter value of PROCESSES
must be set to be no less than the maximum number of concurrent clients.
During the sync, the Data Synchronization will make changes to the publication map tables. One DML lock is needed for each client and changed publication:
DML_LOCKS
= (Number of changed publications) * (Maximum number of concurrent clients)
During the first and second sync, all publication map tables are changed for each client. So, the required DML locks are:
DML_LOCKS
= (Number of publications) * (Maximum number of concurrent clients)
If you have a large number of publications, the default DML_LOCKS
may not be sufficient. You should set it explicitly in the file init.ora
. For example, CRM has approximately 50 publications. For 30 concurrent first syncs, Data Synchronization needs 1500 DML locks. The default value for DML_LOCKS
with PROCESSES
set to 200 is 1000.