Propagation latency - Definition - Oracle Replication

Q.  The delay between the time a DML change is applied at the originating database and the time the transaction reaches the destination databases is called as _______ .
- Published on 13 Aug 15

a. Propagation
b. Propagation latency
c. Conflict
d. Conflict latency

ANSWER: Propagation latency
 

    Discussion

  • Nirja Shah   -Posted on 18 Sep 15
    - When Oracle propagates an update to destination tables, it expects the current data for the row at the destination to match the data at the originating site prior to the update.

    - If the data is not the same, an update conflict results.

    - Similarly, if an insert fails because of a primary key violation (i.e., a unique constraint violation) the result is a uniqueness conflict or violation.

    - If the target row of a delete does not exist at the destination site, a delete conflict results.

    - Unless you are propagating changes among master sites synchronously, there is a delay between the time a DML change is applied at the originating database and the time the transaction reaches the destination databases.

    - This lag is known as propagation latency.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)