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 useMIN_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 |
|
No. Oracle Database with iPR |
No, Oracle Database |
Yes |
Yes |