ORA-600 [ktrgcm_3] 解決方案

最近，有一個資料庫總是報ORA-00600 ktrgcm_3錯誤，該資料庫的版本為Oracle 10.2.0.5.5 for linux x86_64。
具體錯誤資訊如下：
Fri May 25 14:10:41 CST 2012
Errors in file /u01/app/oracle/admin/webdb/udump/webdb1_ora_2979.trc:
ORA-00600: internal error code, arguments: [ktrgcm_3], [], [], [], [], [], [], []
Fri May 25 14:11:14 CST 2012
Trace dumping is performing id=[cdmp_20120525141114]

在metalink上查實，該錯誤是此版本的bug。參見文檔 Bug 14076510 - ORA-600 [ktrgcm_3] in 10.2.0.5.3 - 10.2.0.5.7 [ID 14076510.8]
   
確認影響的產品資訊如下：
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    

    10.2.0.5.7 Patch Set Update
    10.2.0.5.6 Patch Set Update
    10.2.0.5.5 Patch Set Update
    10.2.0.5.4 Patch Set Update
    10.2.0.5.3 Patch Set Update

Platforms affected    Generic (all / most platforms affect

沒有提供修複補丁包。但提供的臨時解決方案，將隱含參數"_row_cr"設定為FALSE，其副作用是會降低效能。

操作方法如下：

ALTER SYSTEM SET _row_cr=FALSE SCOPE=BOTH SID='*';

官方描述如下：
  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.
    
這個文檔 Ora-600 [Ktrgcm_3] [ID 739745.1]    中提供的trc資訊和我們webdb1_ora_2979.trc檔案中的資訊也是一致的。

此文檔也可以去參考一下。

更多Oracle相關資訊見Oracle 專題頁面 http://www.bkjia.com/topicnews.aspx?tid=12