Oracle 10g出现ORA-00600错误的解决方案

今天又一同事遇到一个Oracle数据库bug问题，如下：--Oracle 10.1 OR 10.2中所有平台都存在该问题.<问题现像>
在进行多表关联复杂查询时出现
ORA-00600: 内部错误代码, 参数: [19004], [], [], [], [], [], [], []
错误<解决办法>
这是一个ORACLE的BUG
处理办法1:
以DBA身份执行:
execute dbms_stats.delete_schema_stats（"schema owner"）;处理办法2:
如果只有个别表在查询时出现错误,可以只对出错表理行处理
execute dbms_stats.delete_table_stats（"schema owner","table"）;此问题的英文资料：This document is being delivered to you via Oracle Support"s Rapid Visibility （RaV） Rapid Visibility （RaV） process, and therefore has not been subject to an independent technical review.
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1 to 10.2
This problem can occur on any platform.Symptoms
Alert log reports the following errors several times:
ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], []Trace file reports current SQL executed via SQLPlus which includes many aggregates and multijoins:
SELECT bill_rd_id_1_label,ultimate_orig_15_label,ultimate_orig_9_label,ultimate_orig_2_label, SUM（
VALUE_1 ）,
SUM（ VALUE_2 ）,SUM（ VALUE_3 ）,SUM（ VALUE_4 ）,SUM（ VALUE_5 ）,SUM（ VALUE_6 ）,SUM（ VALUE_7 ）,
SUM（ VALUE_8 ）,SUM（ VALUE_9 ）,SUM（ VALUE_10 ）,SUM（ VALUE_11 ）,SUM（ VALUE_12 ）,SUM（ VALUE_13 ）,SUM（
VALUE_14 ）,SUM（ VALUE_15）,....."136 - LONG LOG FLAT","138 - PLAIN AND EQUP FLAT","139 - HEAVY DUTY FLAT","140 - FRAME AND
PEDESTAL FLAT",
"141 - CENTER BEAM FLAT","142 - OTHER CAR TYPE","143 - BI LEVEL FLAT","144 - TRI LEVEL FLAT","145
- IM CONVENTIONAL CAR （P）",
"146 - IM ARTICULATED SPINE CAR （Q）","147 - TRAILERS","148 - CONTAINERS","149 - TANK CAR","150 -
LOCOMOTIVE","151 - MOW CAR",
"152 - CABOOSE","155 - ROAD RAILERS AND CHASIS","160 - IM STACK CAR （S）","180 - WET ROCK
HOPPER","UNKNOWN","unknown CAR_TYPE_3"）
AND driver_cube_300.car_type_key=valid_car_type_300.car_type_key
AND driver_cube_300.bill_rd_id_key=valid_bill_rd_id_300.bill_rd_id_key
AND driver_cube_300.ultimate_orig_key=valid_ultimate_orig_300.ultimate_orig_key
AND driver_cube_300.lob_key=valid_lob_300.lob_key
AND driver_cube_300.time_key=valid_car_type_300.time_key
AND driver_cube_300.time_key=valid_bill_rd_id_300.time_key
AND driver_cube_300.time_key=valid_ultimate_orig_300.time_key
AND driver_cube_300.time_key=valid_lob_300.time_key
AND driver_cube_300.time_key=periods.time_key
AND driver_cube_300.time_key IN （ "33","34","35"）
GROUP BY bill_rd_id_1_label,ultimate_orig_15_label,ultimate_orig_9_label,ultimate_orig_2_label
ORDER BY bill_rd_id_1_label,ultimate_orig_15_label,ultimate_orig_9_label,ultimate_orig_2_label
Cause
Unpublished Bug 4899105 - Multitable join could get ORA-600[19004], if some of join columns have histograms.
Fixed In Ver: 11.0
Workaround:
gather statistics without histograms1. Stack （kkejeq kkepsl kkeidc kketac kkonxc kkotap） matches Bug 5041016 closed as duplicate of Bug 4899105.
2. Multitable join matches condition of internal Bug 4899105
Solution
1. Implement WorkaroundWorkaround A:Regather statistics without histogramsThere is no way to only remove the histograms. You would need to re-collect statistics without the histograms.Using dbms_stats package - you would spe更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Node.js 操作 PostgreSQL 数据库Oracle递归START WITH...CONNECT BY PRIOR子句用法相关资讯 ORA-00600

ORA-00600（13013）错误解决方法（今 07:47）
ORA-00600: internal error code, （04月19日）
ORA-00600 错误解决一例（10/21/2015 20:56:11）

一个SQL语句引发的ORA-00600错误排（07月21日）
cursor_sharing引发的ORA-00600错（01月09日）
遭遇 ORA-00600: internal error （09/17/2015 19:21:46）

本文评论查看全部评论（0）