Oracle GoldenGate integrated extract and replicat uses the stream pool, which is a shared memory in System Global Area (SGA) defined by STREAMS_POOL_SIZE. By default, the STREAMS_POOL_SIZE is 1GB. If you have more than one extract process, you then need to following the formula [1] [2]:
- (Number of Extract) x (MAX_SGA_SIZE or 1GB) x 1.25
- 3 x 1 GB x 1.25=3.75GB
The MAX_SGA_SIZE is define in the extract parameter file. The following is an example:
TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 2048, _LOGMINER_READ_BUFFERS 256)
You can check the current stream_pool_size setting with the following SQL command:
select current_size from v$sga_dynamic_components where component = 'streams pool';
The Integrated replicat also needs to have 1GB STREAMS_POOL_SIZE per process and additional 25 percent memory. [2]
Resources
- Advisor Webcast: Oracle GoldenGate Performance Best Practices
- Oracle A-Team Blog, Memory requirement for Oracle GoldenGate Integrated Extract, May 14, 2013
- 2078459.1 Integrated Extract / Replicat and STREAMS_POOL_SIZE