In Oracle GoldenGate when using Integrated Mode, STREAMS_POOL plays an Vital role. The Integrated process, takes the shared memory from the “STREAMS POOL”.
STREAMS POOL is one of the memory components of the SGA. It is given as STREAMS_POOL_SIZE. The STREAMS_POOL_SIZE should be sized according to the number of Integrated Extracts used in the Database System. We should also take considerations of other process which uses the STREAMS POOL in the database.
By default, Each Integrated Extract process requests the logmining sever to run with MAX_SGA_SIZE of 1G. MAX_SGA_SIZE is the “STREAMS POOL SIZE”. While Configuring the Integrated Extract we use to give the below parameter.,