相信大家都有遇到ora-04031這種錯誤，在匯出時也有這樣的錯誤出現。

問題的症狀：
expdp 報告如下錯誤：
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_FULL_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39080: failed to create queues "KUPC$C_1_20070823095248" and "KUPC$S_1_20070
823095248" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1580
ORA-04031: unable to allocate 4194344 bytes of shared memory ("streams pool","unknown object","streams

pool","fixed allocation callback

問題原因：
這個問題是由於設定了初始化引數streams_pool_size 的值為0，錯誤的第一個提示 streams pool 就能夠說明問題的原

因。
ora-4031 一般說明記憶體過小，應該加大記憶體的大小。
解決辦法：
設定初始化引數streams_pool_size 的值最小為48m
alter system set streams_pool_size =48m；

Note: for a large database and/or high workload, the STREAMS_POOL_SIZE parameter may need to be higher

(如 150 MB) in order to avoid the ORA-4031 errors.

EXPDP Fails With ORA-04031 ("streams pool", ...)

相關文章