| |
- Streams pool is a part of System Global Area (SGA) from which memory for Streams is allocated if it is configured. It can be configured by specifying initialization parameter, STREAMS_POOL_SIZE.
- If the size of the Streams pool is greater than zero, then any SGA memory used by Stream is allocate from the Streams pool.
- If the size of the Stream pool is equal to zero, then the memory used by Streams is allocated from the shared pool that may use up to 10% of the shared pool.
|
Oracle Streams Interview Question and Answers