Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Ask DBA › Question Id: 3987 | Permalink

Data pump jobs

Question ID: 3987
Created By: 2010-MAR-28 10:53:57 [Singireddidba]
Updated By: 2010-MAR-31 20:23:05 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
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