|Oracle® Database Reference
12c Release 1 (12.1)
|PDF · Mobi · ePub|
|Parameter type||Big integer|
|Range of values||Minimum:
Maximum: operating system-dependent
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.
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 Streams, 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.
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 GoldenGate for Windows and UNIX Administrator's Guide
Oracle Database PL/SQL Packages and Types Reference for more information about the