Skip Headers

Oracle® Database Lite Administration and Deployment Guide Release 10.3 Part Number E12089-02 |
Home | Book List | Contents | Index | Contact Us

Previous | Next
| View PDF

# B Data Synchronization Requirements in INIT.ORA

The following sections describe the Data Synchronization requirements for Oracle and Oracle parameter settings in the `init.ora` file:

- Section B.1, "Relationships Between Relevant Parameters"

- Section B.2, "Values for Processes and DML Locks"

## B.1 Relationships Between Relevant Parameters

You should set the following parameters in the file `init.ora` as given below:

Table B-1 lists parameters that must be set in the file `init.ora`:

Table B-1 init.ora Parameter Settings

Parameter Name | Definition
--- | ---
`PROCESSES` | Default value: 59 to 200.
`SESSIONS` | Default value: Derived: `1.1 * PROCESSES + 5`
`TRANSACTIONS` | Default value: Derived: `(1.1 * SESSIONS`)
`DML_LOCKS` | Default Value: Derived: `(4 * TRANSACTIONS)`

## B.2 Values for Processes and DML Locks

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.