Home » Server Options » Streams & AQ » Streams implementation experiences
Streams implementation experiences [message #75708] Mon, 24 May 2004 07:55
Messages: 95
Registered: November 2000
We are in the process of evaluating Oracle Streams for our delta detection needs to build an Operational Data Store (ODS) from an OLTP database. We have tested some basic functionality of Streams to capture/propagate and apply source database changes.

However, we have the following concerns that we need to put to rest before taking up Streams with confidence. I will appreciate anybody sharing their experiences.

(a) What kind of performance impact should we anticipate on OLTP database?
(b) Is there a possibility of losing transactions in OLTP database due to any Streams related issues?
(c) Are there any published benchmarks?
(d) Are there any thumb-rules for calculating additional memory/disk etc to set up streams?

Thanks and appreciate any help
Previous Topic: oracle streams. are they supported in 9.0.1.x ?
Next Topic: Streams - capturing and propagating only inserts on table
Goto Forum:

Current Time: Tue Aug 22 23:14:30 CDT 2017

Total time taken to generate the page: 0.01833 seconds