STREAMS_POOL

STREAMS_POOL_SIZE

Property	Description
Parameter type	Big integer
Syntax	`STREAMS_POOL_SIZE =` `integer` `[K \| M \| G]`
Default value	`0`
Modifiable	`ALTER SYSTEM`
Range of values	Minimum: `0` (values greater than zero are rounded up to the nearest granule size) Maximum: operating system-dependent

STREAMS_POOL_SIZE specifies (in bytes) the size of the Streams pool, from which memory is allocated for Streams. If this parameter is not specified or is set to 0, then up to 10% of the shared pool is allocated for Streams.

See Also:

Oracle Streams Concepts and Administration for more information on setting this parameter