ORA-04030: out of process memory ...(initSubHeap:qk...)的錯誤解決
現象:
執行
SELECT s.index_name, s.table_name, s.uniqueness, s.index_type, s.table_owner FROM all_indexes s WHERE owner = 'BJJH' AND (funcidx_status IS NULL OR funcidx_status != 'DISABLED') AND table_name not in (SELECT object_name table_name FROM all_objects WHERE owner = 'BJJH' AND object_type = 'TABLE' AND table_name in (SELECT table_name from all_snapshots where owner = 'BJJH' )) AND index_name not in (select constraint_name from all_constraints where table_name=s.table_name AND owner= 'BJJH' AND constraint_type iN ('P','U'))時出錯,報
ORA-04030: out of process memory when trying to allocate 82464 bytes錯誤。
在資料後臺日誌中也出現:
Errors in file /u01/app/oracle/base/database/diag/rdbms/lisdbuat/lisdbuat/trace/lisdbuat_ora_15597602.trc (incident=192444):
ORA-04030: out of process memory when trying to allocate 82464 bytes (initSubHeap:qk,travElemP:qkspmTravCreate)
Incident details in: /u01/app/oracle/base/database/diag/rdbms/lisdbuat/lisdbuat/incident/incdir_192444/lisdbuat_ora_15597602_i192444.trc
的錯誤資訊。
解決:
查詢Oracle Support, 確認是由於觸發了BUG引起的。透過修改:
alter system set "_optimizer_reuse_cost_annotations" = FALSE;
alter system set "_push_join_predicate" = FALSE;
alter system set "_fix_control"='5302124:off';
alter system set "_optimizer_fast_pred_transitivity" = false ;
幾個隱含引數後,問題得以解決。
執行
SELECT s.index_name, s.table_name, s.uniqueness, s.index_type, s.table_owner FROM all_indexes s WHERE owner = 'BJJH' AND (funcidx_status IS NULL OR funcidx_status != 'DISABLED') AND table_name not in (SELECT object_name table_name FROM all_objects WHERE owner = 'BJJH' AND object_type = 'TABLE' AND table_name in (SELECT table_name from all_snapshots where owner = 'BJJH' )) AND index_name not in (select constraint_name from all_constraints where table_name=s.table_name AND owner= 'BJJH' AND constraint_type iN ('P','U'))時出錯,報
ORA-04030: out of process memory when trying to allocate 82464 bytes錯誤。
在資料後臺日誌中也出現:
Errors in file /u01/app/oracle/base/database/diag/rdbms/lisdbuat/lisdbuat/trace/lisdbuat_ora_15597602.trc (incident=192444):
ORA-04030: out of process memory when trying to allocate 82464 bytes (initSubHeap:qk,travElemP:qkspmTravCreate)
Incident details in: /u01/app/oracle/base/database/diag/rdbms/lisdbuat/lisdbuat/incident/incdir_192444/lisdbuat_ora_15597602_i192444.trc
的錯誤資訊。
解決:
查詢Oracle Support, 確認是由於觸發了BUG引起的。透過修改:
alter system set "_optimizer_reuse_cost_annotations" = FALSE;
alter system set "_push_join_predicate" = FALSE;
alter system set "_fix_control"='5302124:off';
alter system set "_optimizer_fast_pred_transitivity" = false ;
幾個隱含引數後,問題得以解決。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/13885898/viewspace-2157611/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle LOGICAL standby ORA-04030: out of process memoryOracle
- ORACLE ORA-04030之 out of process memory when trying to allocateOracle
- AIX平臺下報ORA-04030: out of process memory when trying to allocate string bytesAI
- Go:錯誤 could not launch process: EOF 解決Go
- Ubuntu Cannot allocate memory 錯誤解決方案Ubuntu
- windows 32位ORA-27102: out of memory錯誤Windows
- 解決MYSQL工具mysqldump 遇到 Out of memory 方法MySql
- A significant part of sql server process memory has been paged outNifiSQLServer
- Out of memory: Kill process 2249 (nginx) score 1 or sacrifice childNginx
- 解決某系統批量出現ora-04030錯誤的方法
- solaris上建立oracle資料庫出現:out of memory 錯誤Oracle資料庫
- ORA-27102: out of memory故障解決
- oracle使用記憶體的錯誤,ORA-27102: out of memoryOracle記憶體
- 由node的批量requests引起的”heap out of memory”解決方案
- Allowed memory size of 134217728 bytes 錯誤解決心得
- 【ERROR】ORA-27102: out of memory 解決方法Error
- ORA-27102: out of memory解決辦法
- 案例分析:ora-04031與ora-04030錯誤分析與解決
- ORA-27102: out of memory 問題解決方法
- OOM(Out Of Memory)OOM
- java out of memoryJava
- 資料庫增加SGA,導致ORA-27102: out of memory錯誤資料庫
- Win10系統玩cf出現out of memory的解決方法Win10
- git post資料過大報錯-Out of memoryGit
- ora-27100:shared memory realm already exists錯誤的解決
- OOM--OUT OF MEMORYOOM
- Composer 記憶體不足解決方案 PHP Fatal error: Out of memory記憶體PHPError
- ora-01034 ora-27121 Cannot allocate memory錯誤解決
- ORA-27101 Shared memory realm does not exist錯誤解決方案
- ORA-27100 shared memory realm already exists錯誤解決
- 【ORACLE】ORA-27102: out of memory報錯的處理Oracle
- Java Out Of Memory解決之JAVA_OPTS引數說明與配置Java
- Job for mysqld.service failed because the control process exited with error code錯誤解決MySqlAIError
- 解決Android 虛擬機器執行The emulator process for AVD was killed.錯誤。Android虛擬機
- Nginx 報錯 504 Gateway Time-out 的解決方法NginxGateway
- nginx “504 Gateway Time-out”錯誤NginxGateway
- Oracle11.1.0.7版本的ASSM與ORA-04030錯誤OracleSSM
- An out of memory error has occurred.Error