Oracle Streams Enhancements

Previously introduced with Oracle 9.2, Oracle Streams is a lightweight replication feature that enables the sharing of data and events via a data stream within a database or from one database to another. Oracle Database 10g has taken the initial baseline of this technology and greatly enhanced its footprint in the latest version of the database. Following is a short summary of these features now available with Oracle Database 10g.

Streams Architecture

Starting with Oracle Database 10g, you can specify a new SGA pool for Oracle streams memory allocation called the streams pool. This new pool is created by specifying a value for the new dynamic initialization parameter STREAMS_POOL_SIZE. Prior to Oracle Database 10g, ...

Get Oracle® Database 10g Insider Solutions 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.