在给客户写优化方案时，客户的环境是AIX 5.3，ORACLE 10.2.0.4.0，发现客户的告警日志存在ORA-00600错误,如下：

Fri Oct  5 06:20:27 2012
Errors in file /home/oracle/app/admin/wssb/udump/wssb_ora_4272180.trc:
ORA-00600: internal error code, arguments: [kghfrf1], [0x000000000], [], [], [], [], [], []

查看trace文件发现是物化视图刷新的时候触发了这个错误，如下：

*** 2012-10-05 06:20:27.599
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kghfrf1], [0x000000000], [], [], [], [], [], []
Current SQL statement for this session:
BEGIN isso.rph(:1) ; END;
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
70000018ea40960        81  package body SYS.DBMS_SNAPSHOT
70000018ea40960      1727  package body SYS.DBMS_SNAPSHOT
70000018ea40960      2220  package body SYS.DBMS_SNAPSHOT
70000018ea40960      2457  package body SYS.DBMS_SNAPSHOT
70000018d8668a0       685  package body SYS.DBMS_IREFRESH
70000018ea4ff60       195  package body SYS.DBMS_REFRESH
7000001751170d8         3  procedure ISSO.RPH
70000018eb80490         1  anonymous block

经过分析并与MOS（ID 816733.1）对比，发现这是刷新物化视图时触发的BUG（Bug 5879082），该BUG在10.2.0.5和11.2版本已经修复，也可安装Patch:5879082进行修复。

 

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
Applies to: 
Oracle Server - Enterprise Edition - Version: 9.2.0.7 to 11.1.0.6 - Release: 9.2 to 11.1
Information in this document applies to any platform.
Symptoms
On a MV refresh, it can be reported:
ORA-00600: internal error code, arguments: [kghfrf1], [0x000000000], [], [], [], [], [], []
The call stack looks like:
kghfrf kkzufsnap kkzfcobwu kkzfrsh kkzifr3g spefcmpa spefmccallstd pextproc peftrusted psdexsp
rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt
kkxexe
Cause
The cause of this problem has been identified and verified in an unpublished Bug 5879082:
the error ORA-600 [kghfrf1] is reported on MV refresh while doing cleanup of oracle memory.
Solution
Unpublished Bug:5879082 is fixed in Oracle RDBMS 11.1 and 10.2.0.5 release.
There is currently no known workaround available.

Check for the availability of one-off Patch:5879082 for your platform on My Oracle Support.
References
NOTE:5879082.8 - Bug 5879082 - Dump[kghfrf] during refresh of MView
NOTE:139056.1 - ORA-600 [kghfrf1]

本文固定链接: https://www.dbdream.com.cn/2012/10/ora-00600-kghfrf1%e9%94%99%e8%af%af/ | 信春哥，系统稳，闭眼上线不回滚！