To set the save_interval for a database connection, execute the alter connection command at the Replication Server. For example, here is the command to set Replication Server SYDNEY_RS to save for one hour any messages destined for its replicate data server SYDNEY_DS.
alter connection to SYDNEY_DS.pubs2 set save_interval to '60'
By default, the save_interval is set to 0 (minutes).
You can also configure the save intervals for the DSI queue and the materialization queue for a logical connection. See “Configuring logical connection save intervals” for details.
