1.332 STREAMS_POOL_SIZE
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 the
dbms_aqadm
package