ORACLE10G 出现00600的一个BUG的解决方案
来源:互联网 发布:直播刷人气软件 编辑:程序博客网 时间:2024/05/01 11:34
今天又一同事遇到一个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 出现00600的一个BUG的解决方案
- ORACLE10G 出现00600的一个BUG的解决方案
- Oracle10g(10.2.0.1)的一个bug
- 安装Oracle10g后出现的一个path问题?
- 一个第二书店出现的BUG!
- 使用GridView出现的一个bug
- MvcMusicStore学习中常出现的一个BUG
- 学习MVC中出现的一个BUG
- 一个数据读入时出现的BUG
- 使用Mybatis出现的一个异常bug
- springmvc 中出现的RequestMappingHandlerMapping#0的bug解决方案
- docker 删除容器的时候出现的bug解决方案
- 用IE登录Linux服务器上的Oracle10g em出现的乱码的解决方案
- JS浮点数运算出现Bug的解决方案
- ORA-12541:oracle10g 卸载重装后 出现no listener错误的解决方案
- 一个来自Afinal断点下载BUG的解决方案
- 一个来自Afinal断点下载BUG的解决方案
- junit的一个bug+实例验证+解决方案(两种)
- POJ 1141
- Spring 文件上传
- 图片墙的一种实现方式
- 需求变更
- dede调用副栏目文章列表方法
- ORACLE10G 出现00600的一个BUG的解决方案
- c# datatable 数据类型 转 泛型
- Android反编译工具
- 杭电2710
- Apache Shiro Web应用过滤器
- oracle最高效的删除重复记录方法
- PHP原理之内存管理中难懂的几个点
- oracle递归START WITH...CONNECT BY PRIOR子句用法
- 安装Visual Assit 可在VS2010/VC6.0中使用