Hi everyone,

After going through some docs on Oracle Streams concept, I was wondering how much time does it take for the LCR to be propagated to the destination database and on what factor's does this time lag effects. for example lets consider a environment where my primary is in located 300 miles to destination site, all the DML/DDL for scott schema are propagated to the destination through may be via WAN. How reliable is this setup. Will the propagation job will send the LCR as soon as it see's them in the queue table or sends a group of LCR together?.

Thanks in advance