 |
|
streams_pool_size tips
Oracle Tips by Burleson |
Oracle 10g streams_pool_size
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 – This 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 percent of the shared pool is allocated for Streams.
|
