O'Reilly logo

Oracle 11g Streams Implementer's Guide by Eric Yen, Ann L. R. McKinnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configure the database

The Streams environment requires proper configuration of the database initialization parameters that support the underlying functionality prior to the configuration of Capture, Propagate, and Apply process. It also requires that we "turn on" additional redo logging functionality. With all this added activity being turned on, we can expect a larger amount of metadata to be accumulated to keep track of all this. As much of this metadata is dynamic, it can cause fragmentation in the SYSTEM and SYSAUX tablespaces where it would be created by default. Due to this, we also recommend (as does Oracle) to move Logging and Streams schemas to their own tablespaces. This also feeds into the ease of "separation of duties" between tablespaces ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required