UDE-31623 Error with Data Pump Export

来源：互联网发布：手机西西软件盒编辑：程序博客网时间：2024/05/21 18:39

Export: Release 11.2.0.4.0 - Production on Mon Nov 6 09:09:09 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsUDE-31623: operation generated ORACLE error 31623ORA-31623: a job is not attached to this session via the specified handleORA-06512: at "SYS.DBMS_DATAPUMP", line 3326ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551ORA-06512: at line 1

expdp导出数据时候出现问题，查看告警日志，提示如下

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

经过查看，由于streams pool无法分配空间，可以查看内存分配

SQL> show parameter memoryNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------hi_shared_memory_address             integer     0memory_max_target                    big integer 0memory_target                        big integer 0shared_memory_address                integer     0SQL> select * from v$sgainfo;NAME                                  BYTES RES-------------------------------- ---------- ---Fixed SGA Size                      2255032 NoRedo Buffers                       12075008 NoBuffer Cache Size                 167772160 YesShared Pool Size                  373293056 YesLarge Pool Size                           0 YesJava Pool Size                      4194304 YesStreams Pool Size                         0 YesShared IO Pool Size                       0 YesGranule Size                        4194304 NoMaximum SGA Size                  559591424 NoStartup overhead in Shared Pool   288885168 NoNAME                                  BYTES RES-------------------------------- ---------- ---Free SGA Memory Available                 012 rows selected.

data pump数据泵在11g中开始Advanced Queue高级队列来控制其job作业的启动、停止和重启。

如果streams pool的当前size为0，那么显然无法分配到任何内存

重新设置参数streams_pool_size，重启db即可

阅读全文

0 0