數據庫 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;
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.