STREAMS_POOL_SIZE在OGG集成模式中一般设置多大？

查看已有ogg进程数据库对streams_pool_size的占用,可以考虑每个抽取进程=1*1.25个G的分配

create pfile='/home/oracle/s.txt' from spfile;
cat s.txt|grep stream

5个抽取进程：

8个抽取进程：

生产修改：

show parameter streams_pool_size;
alter system set streams_pool_size='8G' scope=both;

参考文档：

Integrated Extract / Replicat and STREAMS_POOL_SIZE (Doc ID 2078459.1)	

Oracle GoldenGate - Version 11.2.1.0.0 and later
Information in this document applies to any platform.
Currency check- 04-17-2017
GOAL
 What is the recommended STREAMS_POOL_SIZE for Integrated Extract (IE) and Integrated Replicat (IR)

SOLUTION
The ogg reference guide recommends to have 1GB STREAMS_POOL_SIZE per integrated extract + additional 25 percent

Snippet from ogg oracle install guide
http://docs.oracle.com/goldengate/1212/gg-winux/GIORA.pdf

------------------------------------------------------

By default, one integrated capture Extract requests the logmining server to run with MAX_SGA_SIZE of 1GB and a PARALLELISM of 2. Thus, if you are running three Extracts in integrated capture mode in the same database instance, you need at least 3 GB of memory allocated to the Streams pool. As best practice, keep 25 percent of the Streams pool available. For example, if there are three Extracts in integrated capture mode, set STREAMS_POOL_SIZE to the following:

3 GB + (3 GB * 0.25) = 3.75 GB

---------------------------------------

The Integrated replicat also needs to have 1GB STREAMS_POOL_SIZE per process and additional 25 percent though it is not been explicitly mentioned in the guides.