ORA-00600: internal error code, arguments: [qkabix], [0], []
ORA-00600: internal error code, arguments: [qkabix], [0], [], [], [], [], [], []
数据库 10.2.0.2
系统 AIX
报错:
Errors in file /orasw/app/Oracle/admin/ebank/udump/ebank_ora_1966346.trc:
ORA-00600: internal error code, arguments: [qkabix], [0], [], [], [], [], [], []
1、阅读trace文件,定位问题SQL
2、查看执行计划时发现 有位图索引的访问路径,但经过检查发现相关对象并没有位图索引
3、查看MOS,,定位文档
4、通过修改隐含参数规避:sql> alter system set "_b_tree_bitmap_plans"=false;
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 09-APR-2012***
SYMPTOMS
The following internal error is reported in the alert log:
ORA-00600: internal error code, arguments: [qkabix], [0], [], [], [], [], [], []
The error is reported running a Select statement.
The call stack looks like:
qkabix qkaix qkatab qkajoi qkaqkn qkadrv opitca kksFullTypeCheck rpiswu2 kksSetBindType kksfbc
kkspfda kpodny kpoal8
The problem could be related to a CBO ( Cost Based Optimizer ) issue when a query uses a bitmap access paths for b-tree indexes.
It was reported in Bug 5945798 but could not be confirmed.
SOLUTIONOne possible workaround to avoid the error is to disable the optimizer to produce bitmap plans for B-Tree indexes, even if there is no bitmap index anywhere in sight.
- at session level:
sql> alter session set "_b_tree_bitmap_plans"=false;
- or at system level:
sql> alter system set "_b_tree_bitmap_plans"=false;
- or in the init.ora/spfile:
_b_tree_bitmap_plans = false
About this "_b_tree_bitmap_plans" parameter.
===============================
_B_TREE_BITMAP_PLANS enables creation of interim bitmap representation for tables in a query with only binary index(es). Default value is FALSE in Oracle 8i and TRUE in Oracle 9i and above.
NOTE:548984.1 - Claim Lines Associate Earnings Flashlight Performance Issues
推荐阅读
-
ORA-00600: internal error code, arguments: [qkabix], [0], []
-
遭遇 ORA-00600: internal error code, arguments: [4194] ORA-155
-
ORA-00600: internal error code, arguments: [13310]
-
ORA-00600: internal error code, arguments: [13310]
-
遇到ORA-00600:internal error code,arguments:[kcblasm_1],[103],[],[],[],[]报错的解决办法
-
ORA-00600: internal error code, arguments: [evapth : unexpec
-
ORA-00600: internal error code, arguments: [4194] ,ORA-00607
-
ORA-00600 internal error code,arguments
-
ORA-00600: internal error code, arguments: [15709]
-
ORA-00600: internal error code, arguments: [4194]解决方法