Do I need to increase streams_pool_size when I do data pump full export?

Posted on 2008-06-23
Medium Priority
Last Modified: 2013-12-18
When I did data pump full export, I got the following error message.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 111
ORA-06512: at "SYS.KUPC$QUE_INT", line 444
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2500
ORA-06512: at "SYS.DBMS_DATAPUMP", line 1509
ORA-06512: at line 1

I got the suggstion from metalink to increase streams_pool_size. But I got the following error when increase it.  
SQL> alter system set streams_pool_size=100M ;
alter system set streams_pool_size=100M
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04033: Insufficient memory to grow pool  

How to fix it?
Question by:luyan
  • 3
  • 2
LVL 23

Expert Comment

ID: 21851809
Try specifying the integer only: 104857600.  Secondly, please look into using the automated memory manager, in which this parameter and others are kept at zero while the instance auto-allocates the SGA components.

Author Comment

ID: 21855818
Can you give me more detail? Thanks!
LVL 23

Accepted Solution

David earned 2000 total points
ID: 21857816
The latter first:  AMM and the other 10g features are easily searched on this site and on the Web.  The attached overview from Mike Ault should be worth your reading for familiarity -- and of course, please get acquainted with www.oracle.com/technology (also known as OTN) for white papers, tutorials, and official documentation.  Another link from my favorites is http://www.akadia.com/services/ora_asm_multiple_block_sizes.html -- might be useful.

The ORA errors suggest that your desired SGA would exceed the max SGA constraint.  You may view your live values with >SHOW PARAMETER SGA.  You might increase sga_max_size, take a restart of the database (since its a static parameter) and then try modifying the streams pool again.
LVL 23

Expert Comment

ID: 21888706
May I be of any further service?

Author Closing Comment

ID: 31469947

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question