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.
