臨時解決:ORA-00600: internal error code, arguments: [19004], [], [],
oracle 11.2.0.1 +linux5.5
alert 日誌報錯:
Sweep [inc][19880]: completed
Sweep [inc][18798]: completed
Tue Jun 04 13:37:01 2013
Errors in file /BI/app/oracle/admin/wlu1/diag/diag/rdbms/wlbi/wlbi/trace/wlbi_ora_13119.trc (incident=18985):
ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [], [], [], [], []
Tue Jun 04 13:37:01 2013
Sweep [inc][18985]: completed
Tue Jun 04 13:37:49 2013
Errors in file /BI/app/oracle/admin/wlu1/diag/diag/rdbms/wlbi/wlbi/trace/wlbi_ora_13119.trc (incident=18986):
ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [], [], [], [], []
這個問題:是效能差的sql語句觸發了oracle的bug
檢視執行計劃也報著個錯誤;
在trace檔案中可找到效能查的sql語句,這邊不方便貼出
臨時解決辦法:
刪除原有的統計資訊:
exec dbms_stats.delete_table_stats(ownname=>user,tabname=>table,cascade_indexes=>true);
user:指表物件的使用者 table:使用者下的表
重新收集統計資訊:
exec dbms_stats.gather_table_stats(ownname=>user,tabname=>table,cascade=>true,method_opt=>'for all columns size 1'
最終解決辦法就是要升級,在網上了解到這個問題 在11.2.0.2中解決~~~
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26723566/viewspace-1454786/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00600: internal error code, arguments: [kpnatdm】Error
- ORA-00600: internal error code, arguments: [525]Error
- ORA-00600: internal error code, arguments: [4194]Error
- ORA-00600: internal error code, arguments: [15753]Error
- ORA-00600: internal error code, arguments: [17087]Error
- ORA-00600: internal error code, arguments: [Cursor not typechecked],Error
- ORA-00600: internal error code, arguments: [32695]Error
- ORA-00600: internal error code, arguments: [13310], [],錯誤解決Error
- ORA-00600: internal error code, arguments: [keltnfy-ldmInit] 錯誤解決Error
- ORA-00600: internal error code, arguments: [kcbgtcr_13], [], [],Error
- ORA-00600: internal error code, arguments: [2662], [0],Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnCloseError
- 轉載:ORA-00600: internal error code, arguments: [504]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]Error
- ORA-00600: internal error code, arguments: [15709]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [],[], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [krvxbpns01], [], [], [], [], [],Error
- ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []Error
- ORA-00600 : internal error code, arguments: [qertbFetchByRowID]Error
- ORA-00600: internal error code, arguments: [2131], [9], [8]Error
- ORA-00600: internal error code, arguments: [13011]Error
- 案例ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [kssadd: null parent]ErrorNull
- ora-00600:internal error code,arguments:[4194],[7],[2],[],[]Error
- ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [729], [4280], [space leak]Error
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [ErrorAST
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],ErrorAST
- ORA-00600: internal error code, arguments: [ksuinfos_modact1]ErrorUI
- ORA-00600: internal error code, arguments: [4194], [4], [31]Error
- ORA-00600: internal error code, arguments: [2103]錯誤Error
- ORA-00600: internal error code, arguments: [kcbgtcr_12], [4]Error
- ORA-00600: internal error code, arguments: [4194], [30], [30], [],Error
- ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]邏輯壞塊解決ErrorAST
- ORA-27090,ORA-00600: internal error code, arguments: [4194],的解決方法Error
- ORA-00600: internal error code, arguments: [knacpft_ProcessFetchedTxns250]Error
- ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [Error