Re: Oracle Streams

  • From: Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx>
  • To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
  • 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@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
> --
> //

thanks and regards
ujang jaenudin | independent consultant

Other related posts: