Error while export using expdp

[gopu_g]

Hi All,

We are getting the below error while doing EXPDP kindly some one suggest.

ORA-39127: unexpected error from call to export_string :=SYS.LT_EXPORT_PKG.schema_info_exp('SYS',1,1,'10.02.00.00.00',newbloc
k)
ORA-04031: unable to allocate 46640 bytes of shared memory ("shared pool","LTADM","PL/SQL MPCODE","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called: "SYS.LTADM"
ORA-06512: at "SYS.LT_EXPORT_PKG", line 843
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5419

[vnktummala]

seems streams_pool_size is small.

Thanks,

[gopu_g]

right now it is 12M, how much would you suggest to increase ?

SQL> sho parameter streams_pool_size ;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size big integer 12M

[vnktummala]

16M will be good.

Thanks,

[gopu_g]

Hi Vijay,


Thanks for the suggestion...
Since this is a production database, before making the changes i wanna confirm this.
Can you explain me that how this error is related to "streams_pool_size"

[vnktummala]

Hi Gopu,

this error usually comes if you are using streams and streams pool size is small. I had the same issue around a month back and resolved it by increasing the streams_pool_size.

Thanks,

[gopu_g]

Thanks for the answer....Good one.

I had google it and sharing with u the answer i got.
-------------------------------------------------

Oracle Data Pump uses Streams functionality to communicate between processes. If the SGA_TARGET initialization parameter is set, then the STREAMS_POOL_SIZE initialization parameter is automatically set to a reasonable value.

If the SGA_TARGET initialization parameter is not set and the STREAMS_POOL_SIZE initialization parameter is not defined, then the size of the streams pool automatically defaults to 10% of the 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. A minimum size of 10M is recommended for STREAMS_POOL_SIZE in order to ensure successful Data Pump operations.

[vnktummala]

Thanks for sharing Gopu. Please update if this change resolved your issue or not.

Thanks,

[gopu_g]

Sure vijay, for that it will take some 2-3 days, we have to get the approval from the Top GUYS . I will let you know Once it is done.
Once more thanks for your quick support.