oracle复制会有延迟吗,oracle goldengate 复制端延时应用参数

DEFERAPPLYINTERVAL

Valid for Replicat

Use the DEFERAPPLYINTERVAL parameter to set an amount of time that Replicat waits before

applying captured transactions to the target database. To determine when to apply the

transaction, Replicat adds the delay value to the commit timestamp of the source

transaction, as recorded in the local GMT time of the source system.

You can use DEFERAPPLYINTERVAL for such purposes as to prevent the propagation of

erroneous changes made to the source data, to control data arrival across different time

zones, and to allow time for other planned events to occur before the data is applied to the

target. Note that by using DEFERAPPLYINTERVAL, you are purposely building latency into the

target data, and it should be used with caution if the target applications are time-sensitive.

To find out if Replicat is deferring operations, use the SEND REPLICAT command with the

STATUS option and look for a status of Waiting on deferred apply.

NOTE If the TCPSOURCETIMER parameter is in use, it is possible that the timestamps of the

source and target transactions could vary by a few seconds, causing Replicat to

hold its transaction (and hence row locks) open for a few seconds. This small

variance should not have a noticeable affect on performance

Default 0 (no delay)

Syntax DEFERAPPLYINTERVAL

Argument Description

A numeric value for the amount of time to delay. The minimum delay

time is the value that is set for the EOFDELAY parameter. The maximum

delay time is seven days.

The unit of time for the delay. Can be:

S | SEC | SECS | SECOND | SECONDS | MIN | MINS | MINUTE | MINUTES | HOUR | HOURS |

DAY | DAYS

Example This example directs Replicat to wait ten hours before posting its transactions.

DEFERAPPLYINTERVAL 10

If a transaction completes at 08:00:00 source GMT time, and the delay time is 10 hours, the

transaction will be applied to the target at 18:00:00 target GMT time the same day.

用以下命令查看是否应用延时

send REPLICAT  RFPFP011 status

如果出现Waiting  on  deferred apply  (2011-11-22 09:09:56)  则启用了DEFERAPPLYINTERVAL参数