Oracle10g出现ORA-00600错误的解决方案
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Oracle10g出现ORA-00600错误的解决方案,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3258字,纯文字阅读大概需要5分钟。
内容图文
![Oracle10g出现ORA-00600错误的解决方案](/upload/InfoBanner/zyjiaocheng/548/6e831f1bfa0d404baa9f7500533dee49.jpg)
在进行多表关联复杂查询时出现ORA-00600: 内部错误代码, 参数: [19004], [], [], [], [], [], [], []错误
今天又一同事遇到一个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 histograms
1. 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 Workaround
Workaround A:
Regather statistics without histograms
There 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
内容总结
以上是互联网集市为您收集整理的Oracle10g出现ORA-00600错误的解决方案全部内容,希望文章能够帮你解决Oracle10g出现ORA-00600错误的解决方案所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。