最近应用程序当运行特定查询语句时会报 错.
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树索引禁用位图访问计划