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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
thanks and regards
ujang jaenudin | independent consultant
http://ora62.wordpress.com
http://blog.dbs247.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
