Re: Oracle Streams
Date: Sat, 4 Feb 2012 08:09:15 +0700
Message-ID: <CABcgmSFHzh_vYO719q9XBhAN4KvZ7grr9Q6f4T-ADkTH_J62-g_at_mail.gmail.com>
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
> peter.barnett_at_cambiahealth.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- 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