Re: Oracle Streams
Date: Sat, 4 Feb 2012 08:09:15 +0700
Recently I run the streams for a small banking industry, well during transaction, sync was very stable (around 20 tps)
during batch, apply site lag around 6 hours :( at the apply side, I put scheduler + procedure to fix the apply error, and yes there is unreasonable error during transaction but this scheduler can fix all the time ( it was set up 10 secs interval).
On 2/3/12, Peter Barnett <regdba_at_yahoo.com> wrote:
> We are looking at keeping a remote database at a vendor site updated.
> Timing is not terribly critical since one of the options is running a batch
> ETL job on a daily basis.
> Another option is to use Oracle Streams. Our previous experience with this
> product has not been very positive but that has been several years ago. It
> was high maintenance for the DBA and we had a problem on the target server
> maintaining RI without disabling a lot of triggers.
> Given the choices, has Streams improved enough to reconsider it?
> Pete Barnett
> Database Technologies Lead
> Cambia Health Solutions
-- thanks and regards ujang jaenudin | independent consultant http://ora62.wordpress.com http://blog.dbs247.com -- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 03 2012 - 19:09:15 CST