首页 / MYSQL / ORA-00600:internalerrorcode,arguments:[ktrgcm_3]

ORA-00600:internalerrorcode,arguments:[ktrgcm_3]

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了ORA-00600:internalerrorcode,arguments:[ktrgcm_3]，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2074字，纯文字阅读大概需要3分钟。

内容图文

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

本来今天晚上我打算进行Oracle数据字典深入研究的，但是在我马上要研究完的时候收到在北京的一个朋友的消息，说是 他们的生成库出问题了，让我看一下帮忙解决一下，我是非常高兴的，帮助别人是我的快乐，同样也提高了自己，，特此在此时此刻记录一下，写完这篇日志在继续我的研究。

trace日志信息如下：

dbfs/oradata/admin/htdb/udump/htdb_ora_704518.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/product/10.2.0.5
System name: AIX
Node name: ECMora01
Release: 3
Version: 5
Machine: 00C05BB64C00
Instance name: htdb
Redo thread mounted by this instance: 1
Oracle process number: 206
Unix process pid: 704518, image: oracle@ECMora01


Affects:

Product (Component) Oracle Server (Rdbms)

Range of versions believed to be affected Versions >= 10.2.0.5 but BELOW 11.1

Versions confirmed as being affected

Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in

  • 10.2.0.5.8 Database Patch Set Update
  • 10.2.0.5 Patch 19 on Windows Platforms

    • 2）
     Description This problem is introduced in Database PSU version 10.2.0.5.3and can affect 10.2.0.5.3 through 10.2.0.5.7 inclusive. The problem can also occur with interim patch 6157713 installedon top of 10.2.0.5.3 through 10.2.0.5.5 inclusive. ORA-600 [ktrgcm_3] can occur in the above releases. Workaround Disabling rowCR (which is an optimization to reduce consistent-read rollbacks during queries) by setting "_row_cr"=FALSE in the initialization files in one workaround. However, this could cause performance degradation of queries - the statistics "RowCR hits" / "RowCR attempts" can help show if this workaround may be detrimental to performance. Note: This issue was previously incorrectly listed as fixed in Windows 10.2.0.5 bundle 17 but the fix did not get included until bundle 19.
    因此我们可以设置_row_cr这个隐含参数。如和设置该参数可以参考我写的《oracle之参数文件深入探究》见

    ORA-00600:internalerrorcode,arguments:[ktrgcm_3] - 文章图片

    内容总结

    以上是互联网集市为您收集整理的ORA-00600:internalerrorcode,arguments:[ktrgcm_3]全部内容，希望文章能够帮你解决ORA-00600:internalerrorcode,arguments:[ktrgcm_3]所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

    内容备注

    版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

    内容手机端

    扫描二维码推送至手机访问。

    本文链接：https://qyyshop.com/info/547063.html

    来源：【匿名】