-
Error while export using expdp
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
Thanks/Gopu
-
seems streams_pool_size is small.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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
Last edited by gopu_g; 10-08-2009 at 03:14 AM.
Thanks/Gopu
-
16M will be good.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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"
Last edited by gopu_g; 10-08-2009 at 03:28 AM.
Thanks/Gopu
-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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.
Thanks/Gopu
-
Thanks for sharing Gopu. Please update if this change resolved your issue or not.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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.
Thanks/Gopu
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|