InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Streams Pool In Oracle 10g? |
|
Answer» 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. 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. |
|