Oracle Streams Interview Question and Answers

17. What is Streams pool in Oracle 10g?
 
  • 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.
 
Your Name Your Email-ID
Your Answer
12345 Page 5 of 5