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