Re: Oracle Streams

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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx
> --
> 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-l


Other related posts: