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.
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, ...