ORA-00600:internalerrorcode,arguments:[ktrgcm_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 - bit 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: 00C05BBC00
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之参数文件深入探究》见