ASMM Improvements in 10g Release 2

Oracle has fixed the memory-related bugs in Oracle Database 10g Release 1.

In Oracle Database 10g Release 2, the Streams pool is automatically managed by the ASMM. The improved Oracle Streams can move data between databases and nodes and keep two or more databases synchronized when updates are made. Database objects can be shared between Oracle databases or between Oracle and non-Oracle databases through the use of Oracle Transparent Gateways.

When you use Streams in a single database, memory is allocated from a pool in the System Global Area (SGA) called the Streams pool. The Streams pool helps with the internal communication of the database during parallel capture and applies operations. The Streams pool ...

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.