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]3、[size=11pt]使用oracle的隐含参数对这个错误进行屏蔽
[size=11pt]"_hash_join_enabled"= false

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

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

Symptoms
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

Cause
The issue was investigated in:
Bug 9800302 - 10.2.0.5 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 10.2.0.5 than earlier releases with more "direct path read" operations or
ORA-600 [kcblasm_1] errors.

Solution
1. Upgrade the database to 11.2.
OR
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.
OR
3. Use the workaround of setting:
"_hash_join_enabled"= false

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】