Oracle 参数 STREAMS_POOL_SIZE 官方解释，作用，如何配置最优化建议
本站中文解释
STREAMS_POOL_SIZE参数指定用于STREAMS子系统操作的内存池大小，此参数通常用于用户记录变更数据的单元，如：LOG_BUFFER，QUEUE_BUFFER，DEQUEUE_BUFFER，SGA_TARGET，PGA_AGGREGATE_TARGET等。
此参数可以通过以下方法来正确设置：
1、使用Oracle提供的默认值：STREAMS_POOL_SIZE的默认值是100M（100MB），系统会自动根据使用的资源进行相应的调整。
2、使用有关的脚本调整STREAMS_POOL_SIZE的值：在资源使用量缓慢或适当的时候，用户可以使用有关的脚本调整STREAMS_POOL_SIZE的值，以提高其最大使用量。
3、调整SGA_TARGET参数的值：如果SGA_TARGET参数的值较小，而STREAMS_POOL_SIZE参数的值较大，则可以考虑调整SGA_TARGET参数的值，以提高STREAMS_POOL_SIZE参数的最大使用量。
4、使用数据库存储：如果可以在Oracle数据库中存储变更数据，则可以有效地减少STREAMS_POOL_SIZE参数的使用量，从而提高SGA内存池的最佳性能。
官方英文解释
The STREAMS_POOL_SIZE value helps determine the size of the Streams pool.
| Property | Description |
|---|---|
|
Parameter type |
Big integer |
|
Syntax |
|
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Range of values |
Minimum: Maximum: operating system-dependent |
|
Basic |
No |
Oracle’s Automatic Shared Memory Management feature manages the size of the Streams pool when the SGA_TARGET initialization parameter is set to a nonzero value. If the STREAMS_POOL_SIZE initialization parameter also is set to a nonzero value, then Automatic Shared Memory Management uses this value as a minimum for the Streams pool.
If SGA_TARGET is set to a nonzero value and STREAMS_POOL_SIZE is not specified or is set to a null value, Automatic Shared Memory Management uses 0 (zero) bytes as a minimum for the Streams pool.
If the STREAMS_POOL_SIZE initialization parameter is set to a nonzero value, and the SGA_TARGET parameter is set to 0 (zero), then the Streams pool size is the value specified by the STREAMS_POOL_SIZE parameter, in bytes.
If both the STREAMS_POOL_SIZE and the SGA_TARGET initialization parameters are set to 0 (zero), then, by default, on the first request for Streams pool memory in a database, an amount of memory equal to 10% of the shared pool is transferred from the buffer cache to the Streams pool. Products and features that use the Streams pool include Oracle GoldenGate, XStream, Oracle Advanced Queuing, and Oracle Data Pump.
The Streams pool is a shared resource, and the amount of memory a process can use from the Streams pool is determined by the application. The capture or apply parameter MAX_SGA_SIZE can be controlled for Oracle GoldenGate or XStream. For Oracle Advanced Queuing, use the procedures in the dbms_aqadm package to control the amount of Streams Pool needed.
See Also:
-
Oracle Database XStream
Guide for information on configuring the Streams pool for an XStream Out configuration -
Oracle Database XStream
Guide for information on configuring the Streams pool for an XStream In configuration -
Oracle Database PL/SQL
Packages and Types Reference for more information about thedbms_aqadmpackage
