Export: Release 11.2.0.4.0 - Production on Mon Nov 6 09:09:09 2017
Copyright (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 Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
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 3326
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-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 memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 0
memory_target big integer 0
shared_memory_address integer 0
SQL> select * from v$sgainfo;
NAME BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size 2255032 No
Redo Buffers 12075008 No
Buffer Cache Size 167772160 Yes
Shared Pool Size 373293056 Yes
Large Pool Size 0 Yes
Java Pool Size 4194304 Yes
Streams Pool Size 0 Yes
Shared IO Pool Size 0 Yes
Granule Size 4194304 No
Maximum SGA Size 559591424 No
Startup overhead in Shared Pool 288885168 No
NAME BYTES RES
-------------------------------- ---------- ---
Free SGA Memory Available 0
12 rows selected.
data pump数据泵在11g中开始Advanced Queue高级队列来控制其job作业的启动、停止和重启。
如果streams pool的当前size为0,那么显然无法分配到任何内存
重新设置参数streams_pool_size,重启db即可