O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

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

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

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