GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Number of streams in an environment.

edited Apr 22, 2013 6:14PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
Hi All, I have a question regarding the number of streams in an environment.

We have a production database and wish to Stream for separate schemas.

My question is: Should we create one stream for all the schemas, or should we create separate and independent streams for the different schemas. How are the two configurations likely to affect performance (speed)? How will they affect reliability?

My current thoughts are to use separate schemas to isolate any problems and make them easier to handle.

So each stream would have separate queue and queue table plus capture, propagation and apply process.

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center