CHAPTER 13Streams Performance Considerations

Oracle has implemented numerous enhancements in Oracle 11g R1 and R2 to improve Streams replication performance. For a simple replication environment with a single source database and a single destination database, you may not have to modify any of the default settings. However, a number of things, such as, insufficient resources, incorrect configuration of various database and Streams processes parameters, transaction size and duration, and application design can adversely affect Streams performance and become bottlenecks in a complex and high-volume environment. Fortunately, there are several actions you can take to improve the Streams performance.

This chapter discusses what can contribute to poor ...

Get Oracle Streams 11g Data Replication now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.