ORA-00600: internal error code, arguments: [qkabix], [0], [], [], [], [], [], []

最近应用程序当运行特定查询语句时会报 错.

ORA-00600: internal error code, arguments: [qkabix], [0], [], [], [], [], [], []
Fri Jul 13 09:49:12 2012
Thread 1 advanced to log sequence 78 (LGWR switch)
  Current log# 1 seq# 78 mem# 0: /redo/oradata/chdyl/redo01a.log
  Current log# 1 seq# 78 mem# 1: /redo/oradata/chdyl/redo01b.log
Fri Jul 13 11:27:34 2012
ORA-01555 caused by SQL statement below (SQL ID: fssnk8qfdvts5, Query Duration=0 sec, SCN: 0x0bad.b50d20a2):
Fri Jul 13 11:27:34 2012
select * from ab13  as of timestamp to_timestamp(:"SYS_B_0",:"SYS_B_1") where aae064=:"SYS_B_2"
在oracle的metalink的回复如下:
Note: This is INTERNAL ONLY research.  No action should be taken by the customer on this information.
This is research only, and may NOT be applicable to your specific situation.

KNOWLEDGE
-----------------
Keywords ora-600 qkabix

Note 743212.1: ORA-00600[Qkabix] Error Caused by a Particular Query

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.'

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.5 - Release: 10.2 to 10.2

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

解决方法是对b树索引禁用位图访问计划

发表评论

电子邮件地址不会被公开。

NOTICE: You should type some Chinese word (like “你好”) in your comment to pass the spam-check, thanks for your patience!