EXPDP Fails With ORA-04031 ("streams pool", ...)
相信大家都有遇到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
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 就能夠說明問題的原
這個問題是由於設定了 初始化引數streams_pool_size 的值為0,錯誤的第一個提示 streams pool 就能夠說明問題的原
因。
ora-4031 一般說明記憶體過小,應該加大記憶體的大小。
解決辦法:
設定 初始化引數streams_pool_size 的值 最小為48m
alter system set streams_pool_size =48m;
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.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-687282/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle imp/impdp報ORA-04031:streams pool,..fixed allocation callback解決/分析Oracle
- SHARED POOL ORA-04031錯誤分析
- DataPump Export (EXPDP) Fails With Error LPX-216 Invalid CharacterExportAIError
- 【MOS】EXPDP Fails ORA-39165: Schema SYS Was Not Found (文件 ID 553402.1)AI
- 【EXPDP】使用EXPDP備份資料時ORA-39125、ORA-04031錯誤原因分析與排查
- ORA-12853和ORA-04031 large pool 不足錯誤解決
- (EXPDP) Fails With Errors ORA-39079 ORA-25306 On One Node In RAC EnvironmentAIError
- buffer cache 和shared pool詳解 診斷和解決ORA-04031 錯誤
- OGG-整合模式抽取與資料庫引數streams_pool_size關係模式資料庫
- 又一次stream_pool不足導致的expdp失敗的解決
- Oracle StreamsOracle
- STREAMS筆記(2) 其他建立Streams的方式筆記
- Oracle 的 KEEP pool, RECYCLE pool和DEFAULT poolOracle
- STREAMS MONITORING
- Kafka Streams 剖析Kafka
- streams 總結
- XDMCP connection failsAI
- 精讀《web streams》Web
- Java 8 Streams filterJavaFilter
- Java 8 Streams map()Java
- ORA-04031錯誤分析
- Azkarra Streams簡介:Apache Kafka Streams的第一個微框架ApacheKafka框架
- 在Oracle11g Streams測試Streams資料傳輸Oracle
- ORACLE記憶體管理 之五 SGA variable pool,shared_pool,large_pool,java_poolOracle記憶體Java
- STREAMS筆記(1) step by step 建立一個Streams複製環境筆記
- Node.js Streams(流)Node.js
- 理解 PHP 中的 StreamsPHP
- STREAMS筆記(6) rule筆記
- Oracle Stream(2)--Streams功能Oracle
- Oracle Stream(1)--Streams概述Oracle
- Oracle expdpOracle
- ORA-04031錯誤詳解
- ora-04031處理過程
- ORA-04031: 無法分配 7411440 位元組的共享記憶體 ("shared pool","TransportHandlingUnitTy6750_T","type object de","KOK記憶體Object
- golang work poolGolang
- Application PoolAPP
- Castor JDO and PoolAST
- oracle large poolOracle