Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-04033: Insufficient memory to grow pool

user584948Nov 6 2017 — edited Nov 7 2017

Hello everyone.  I am trying to do a data pump export of my Oracle 11.1.0.6 database, and I am running into a few hurdles.  When I try and kick off the export, I get this error:

oracle@cpscsdbp11:~> expdp username/password DIRECTORY=DATA_PUMP_DIR DUMPFILE=full_cipca1c_database.dmp LOGFILE=full_cipca1c_exp.log FULL=YES;

Export: Release 11.1.0.6.0 - 64bit Production on Monday, 06 November, 2017 14:43:02

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 11g Release 11.1.0.6.0 - 64bit Production

UDE-31623: operation generated ORACLE error 31623

ORA-31623: a job is not attached to this session via the specified handle

ORA-06512: at "SYS.DBMS_DATAPUMP", line 2862

ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052

ORA-06512: at line 1

When I check the alert log, I see streams_pool_size errors:

ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")

Here are my current database parameters (it's a small production database):

SQL> show parameter target

NAME                                 TYPE                              VALUE

------------------------------------ --------------------------------- ------------------------------

archive_lag_target                   integer                           0

db_flashback_retention_target        integer                           1440

fast_start_io_target                 integer                           0

fast_start_mttr_target               integer                           0

memory_max_target                    big integer                       0

memory_target                        big integer                       0

pga_aggregate_target                 big integer                       24M

sga_target                           big integer                       244M

SQL> show parameter pool

NAME                                 TYPE                              VALUE

------------------------------------ --------------------------------- ------------------------------

buffer_pool_keep                     string

buffer_pool_recycle                  string

global_context_pool_size             string

java_pool_size                       big integer                       0

large_pool_size                      big integer                       0

olap_page_pool_size                  big integer                       0

shared_pool_reserved_size            big integer                       12163481

shared_pool_size                     big integer                       232M

streams_pool_size                    big integer                       0

If I try and increase the streams_pool_size, I get the insufficient memory error:

SQL> alter system set streams_pool_size=48M;

alter system set streams_pool_size=48M

*

ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid

ORA-04033: Insufficient memory to grow pool

Does anyone have any ideas?  Thanks so much everyone.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2017
Added on Nov 6 2017
3 comments
5,205 views