ORA-00600[KCBNEW_3]分析
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了ORA-00600[KCBNEW_3]分析,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2374字,纯文字阅读大概需要4分钟。
内容图文
![ORA-00600[KCBNEW_3]分析](/upload/InfoBanner/zyjiaocheng/548/2a22b170b7e045c7a51e4ee20b11392f.jpg)
系统:AIX数据库版本:10.2.0.3 报错如下:Tue Jan 15 04:08:18 2013Errors in file /Oracle/admin/RASDB/udump/rasdb_ora_76620
系统:AIX
数据库版本:10.2.0.3
报错如下:
Tue Jan 15 04:08:18 2013
Errors in file /Oracle/admin/RASDB/udump/rasdb_ora_766202.trc:
ORA-00600: internal error code, arguments: [kcbnew_3], [0], [8], [1639086], [], [], [], []
查看官方说明:
Summary of Bugs Containing ORA - 00600 [KCBNEW_3] [ID 428568.1]
Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.1.0.6
Information in this document applies to any platform.
This article is intended to
1. Help the reader to understand ORA-00600 [KCBNEW_3] error and how is this caused.
2. List the most common bugs of the aforesaid error and their fixes.
This is a consolidated article based upon various bugs logged for the error ORA-00600 [KCBNEW_3] and gives the reader an overview about the most frequent bugs which the customers are affected with.
The error ORA-00600 [KCBNEW_3] is raised due to the following reason.
A cache buffer holding a database block is in the process of
being reused.
The buffer is in state "current" and may be reused only if the object
is of type temp or undo.
The consistency check comparing the block class in the buffer header
with the block class passed to the cache by the caller is failing.
Bug 4430244 ( Unpublished )
Abstract : ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [KCBNEW_3]
Versions affected : 10.2
Fixed releases : 10.2.0.4, 11.0.0.0
Details : Segment advisor code (eg: DBMS_SPACE.OBJECT_GROWTH_TREND)
can load blocks into the cache for DROPped objects as CURRENT leading
to subsequent operations seeing an incorrect (old) version of a block.
This can lead to various internal buffer cache related errors such as
ORA-600 [kcbnew_3] / ORA-600 [kcbz_check_objd_typ_3].
The exact error depends on which code sees the block.
Backportable : yes to 10.2
Symptoms :
1. ORA-600 [kcbnew_3] internal error reported in the alert.log
2. May occur if segment advisor and DROP operation are being run
concurrently on the same object.
Workaround :
sql>alter system flush buffer cache' to flush the buufer in the cache.
Patch Details:
Check Metalink for Patch 4430244 availability.
解决方法:
1.临时解决方法可以清空缓存区。
2.可以打Patch 4430244小补丁
内容总结
以上是互联网集市为您收集整理的ORA-00600[KCBNEW_3]分析全部内容,希望文章能够帮你解决ORA-00600[KCBNEW_3]分析所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。