Configure the Streams pool for integrated replication on Goldengate
When using integrated Replicat the Streams pool must be configured.
If using non-integrated Replicat the Streams pool is not necessary.
The size requirement of the Streams pool for integrated Replicat is based on a single parameter, MAX_SGA_SIZE. The MAX_SGA_SIZE parameter defaults to INFINITE which allows the Replicat process to use as much of the Streams pool as possible. Oracle does not recommend setting the MAX_SGA_SIZE parameter.
Set the STREAMS_POOL_SIZE initialization parameter for the database to the following value:
(1GB * # of integrated Replicats) + 25% head room
For example, on a system with one integrated Replicat process the calculation would be as follows:
(1GB * 1) * 1.25 = 1.25GB STREAMS_POOL_SIZE = 1280M
For example, on a system with two integrated Replicat process the calculation would be as follows:
(1GB * 2) * 1.25 = 2.25GB STREAMS_POOL_SIZE = 2560M