ORA-00600: internal error code, arguments: [kkobmid], [], [], [], [], [], [], []

taoy_2008

最近时间生产库频繁出现如下错误：

ORA-00600: internal error code, arguments: [kkobmid], [], [], [], [], [], [], []

数据库版本为10.2.0.4.0  HPUX 操作系统。

dbatravel

Bug 6642751  Dump (qkabxo) from FIRST_ROWS_K if bitmap index chosen / OERI:kkobmid
        ORA-600 [kkobmid] (Doc ID 728294.1)

Maclean Liu(刘相兵

odm finding:
ORA-00600: internal error code, arguments: [kkobmid] (Doc ID 735912.1)

Modified 27-OCT-2011 Type PROBLEM Status PENDING_DELETE(EXTERNAL) Priority 3 To Bottom

In this Document

Symptoms

Cause

Solution

References

Symptoms

Query with subquery and ORDER BY fails with

ORA-00600: internal error code, arguments: [kkobmid], [], [], [], [], [], [], [].

Stack trace

kgeasnmierr kkobmid kkoqcp kkoipt kkoqbc

apakkoqb apaqbdDescendents apaqbdListReverse

apaqbdDescendents apaqbdListReverse apaqbd

or

kgeasnmierr kkobmid kkoqcp kkoDMopt kkooqb kkoqbc apakkoqb

Database parameters show:

optimizer_index_caching integer 90

optimizer_index_cost_adj integer 15

The error is eliminated when

1. optimizer_index_cost_adj is set 50, or

2. the ORDER BY is removed.

Cause

The problem has been investigated under bug 6933930 and is fixed by the changes made for bug 6642751.

Solution

When available, download Patch 6642751 to resolve this issue. Alternatively, set optimizer_index_cost_adj to 50

as a workaround.