Data pump jobs
|
11238
2010-MAR-28 10:53:57
|
|
User
|
|
|
Registered On: Feb 2010
Total Posts: 24
|
|
Hi
Generally Data pump jobs are server side jobs , so we need to set the parameter
called stream_pool_size , Is it mandatory parameter or optional ,,and if we
didn't set this parameter then data pump jobs are working are not ? if its
worked ..in which portion of memory is allocated for data pump jobs ,
Thank u
Bhaskar
|
11250
2010-MAR-31 20:23:05
|
|
Moderator
|
|
|
Registered On: Mar 2006
Total Posts: 289
|
|
Here's the answer:
"As of Oracle Database 10g release 10.2, if Streams
functionality is used, but the STREAMS_POOL_SIZE
initialization parameter is not defined, then the
size of the streams pool automatically defaults to
10% of size of the shared pool.
When the streams pool is created, the required SGA
memory is taken from memory allocated to the buffer
cache, reducing the size of the cache to less than
what was specified by the DB_CACHE_SIZE
initialization parameter. This means that if the
buffer cache was configured with only the minimal
required SGA, then Data Pump operations may not
work properly."
REFERENCE:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_perf.htm#sthref451