How much STREAMS_POOL_SIZE for expdp??
510293Jul 19 2007 — edited Jul 19 2007Hi, all.
How much memory is good for streams_pool_size for expdp?
24M is enough for expdp?
Is there any performance effect for expdp?
The database is 10.2.0.2.0 and do not use replication.
The follwoing is part of http://download.oracle.com/docs/cd/B19306_01/server.102/b14229/strms_prop.htm#STRMS150 .
----------------
The Streams pool is initialized the first time any one of the following actions occur in a database:
1. A message is enqueued into a buffered queue. Data Pump export and import operations initialize the Streams pool because these operations use buffered queues.
2. A capture process is started.
3. An apply process is started.
----------------
Thanks and Regards.
Message was edited by:
user507290