Deciding Which Replicat Method to Use

The Replicat process applies replicated data to an Oracle target database.

For an Oracle target database, you can run Replicat in parallel, non-integrated or integrated mode. Oracle recommends that you use the parallel Replicat unless a specific feature requires a different type of Replicat.

The following table lists the features supported by the respective Replicats.

Feature Parallel Replicat Integrated Replicat Coordinated Replicat Classic Replicat

Batch Processing

Yes

Yes

Yes

Yes

Barrier Transactions

Yes

Yes

Yes

No

Dependency Computation

Yes

Yes

No

No

Auto-parallelism

Note:

Auto-parallelism is disabled, by default. Only four threads are used in the default settings. If you want to change Replicat to use MIN_PARALLELISM and MAX_PARALLELISM then auto-parallelism is used.

Yes

Yes

No

No

DML Handler

Yes, Integrated mode

Yes

No

No

Procedural Replication

Yes, used for integrated Parallel Replicat (iPR)

Yes

No

No

Auto CDR

Yes, used by iPR only

Yes

No

No

Dependency-aware Transaction Split

Yes

No

No

No

Cross-RAC-node Processing

Yes

No

Yes

No

ALLOWDUPTARGETMAP

See ALLOWDUPTARGETMAP | NOALLOWDUPTARGETMAP

No. Oracle Database with iPR

No, Oracle Database

Yes

Yes