Interview Questions and Answers PDF free download for freshers and beginners, Multiple Choice Questions (MCQs), Placement Papers
What is Streams pool in Oracle 10g? | Oracle DBA
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 Streams is allocated from the Streams pool. If the size of the Streams 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.