文档地址:http://docs.oracle.com/cd/B19306_01/server.102/b14229/strms_prop.htm#CHDEICJD
Streams Pool Size Set by Default
STREAMS_POOL_SIZE
and theSGA_TARGET
initialization parameters are set to0
(zero), then, by default, the first use of Streamsin a database transfers an amount of memory equal to 10% of theshared pool from the buffer cache to the Streamspool. DB_CACHE_SIZE
initialization parameter, and the sharedpool size is set by the SHARED_POOL_SIZE
initialization parameter.
For example, consider the following configuration in a databasebefore Stream