Oracle数据库出现报错ORA-00600: internal error code, arguments: [kcblasm_1], […

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:127

Oracle数据库出现报错ORA-00600: internal error code, arguments: [kcblasm_1], [103]

Oracle数据库出现报错ORA-00600: internal error code, arguments: [kcblasm_1], [103],经分析,这是一个oracle bug 9800302,解决办法如下三点:

[size=11pt]1、[size=11pt]升级数据库从oracle 10g至Oracle 11.2

[size=11pt]2、[size=11pt]在现有的数据库上打patch [size=11pt]7612454

[size=11pt]"_hash_join_enabled"= false

关于oracle metalink对这个ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []的说明如下:

Applies to:
Oracle Server - Enterprise Edition - Version: and later [Release: 10.2 and later ]
Information in this document applies to any platform.

When executing a statement using a SELECT getting:
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []
The execution plan from the ORA-600 trace file is showing hash join is used.
Call Stack is including:
kcblasm1 kcblasm kxhfFndFreeSlot kxhfNewBuffer qerhjGetNewBuffer ksxb1bqb kxhrPack

The issue was investigated in:
Bug 9800302 - GETTING ORA-00600 [KCBLASM_1]
closed as duplicate of:Bug 7612454 - Abstract: DSS:PERF REGRESSIONS IN SERIAL DIRECT READS fixed in 11.2.
As per development team the number of slots available for direct I/Os (limited to 4096) forced the hash-join algorithm to operate on fewer number of slots and resulted in more spills to disk. This caused:
direct path IO to perform worse in than earlier releases with more "direct path read" operations or
ORA-600 [kcblasm_1] errors.

1. Upgrade the database to 11.2.
2. Apply &incFamilyProds=false&flag=search))" target=_blank>Patch 7612454 available on MOS. If a patch is not currently available on top of your database version and/or platform please raise a Service Request to request for it.
Please be sure that your database version qualifies for getting a new patch as per Note 209768.1 and Note 742060.1.
3. Use the workaround of setting:
"_hash_join_enabled"= false