ORA-00600:internalerrorcode,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.

One 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. REFERENCES BUG:5945798 - ORA-00600 [QKABIX] WHILE RUNNING A SELECT STATEMENT
NOTE:548984.1 - Claim Lines Associate Earnings Flashlight Performance Issues

声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com