GoldenGate Streams Pool Config

Configure the Streams pool

When using Extract in integrated capture mode, an area of Oracle memory called the Streams pool must be configured in the System Global Area (SGA) of the database. 7

ORACLE GOLDENGATE PERFORMANCE BEST PRACTICES

The size requirement of the Streams pool for Extractin integrated capture mode is based on the number of integrated Extracts and the integrated capture mode parameter,
MAX_SGA_SIZE, which controls the amount of shared memory used by the LogMiner server. The default value is 1GB which is adequate in almost all cases. This is not the same as the database initialization parameter, SGA_MAX_SIZE.

Set the STREAMS_POOL_SIZE
initialization parameter for the database to the following value:
(MAX_SGA_SIZE * # of integrated Extracts) + 25% head room

For example, using the default values for the
MAX_SGA_SIZE

with two integrated Extracts:
( 1GB * 2 ) * 1.25 = 2.50GB
STREAMS_POOL_SIZE = 2560M