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文件，定位问题SQL2、查看执行计划时发现有位图索引的访问路径，但经过检查发现相关对象并没有位图索引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

CAUSE

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.

SOLUTION

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更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12MySQL5.6.12造成CPU的使用率 2000%的原因Oracle中表添加带有默认值列的讨论（包括11G新特性）相关资讯 ORA-00600

ORA-00600（13013）错误解决方法（今 07:47）
ORA-00600: internal error code, （04月19日）
ORA-00600 错误解决一例（10/21/2015 20:56:11）

一个SQL语句引发的ORA-00600错误排（07月21日）
cursor_sharing引发的ORA-00600错（01月09日）
遭遇 ORA-00600: internal error （09/17/2015 19:21:46）

本文评论查看全部评论（0）