客户9208环境出现ORA-600[kgavsd_3]错误。
错误信息为：
Thu DEC 15 15:47:57 2011 Errors IN file /oracle/admin/orcl/udump/orcl2_ora_659472.trc: ORA-00600: internal error code, arguments: [kgavsd_3], [0], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 2 ORA-03113: end-of-file ON communication channel ORA-03113: end-of-file ON communication channel ORA-06512: at "DB_USER.P_JOB", line 79 ORA-06512: at line 3 ORA-06508: PL/SQL: could NOT find program unit being called ORA-06512: at line 1 Thu DEC 15 15:47:58 2011 Trace dumping IS performing id=[cdmp_20111215154758] |
类似的错误还出现过两次，一次也是ORA-3113错误导致的：
Thu DEC 15 16:49:00 2011 Errors IN file /oracle/admin/orcl/udump/orcl2_ora_906034.trc: ORA-00600: internal error code, arguments: [kgavsd_3], [0], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 1 ORA-03113: end-of-file ON communication channel Thu DEC 15 16:49:02 2011 Trace dumping IS performing id=[cdmp_20111215164902] |
而另一次是被用户取消所致：
Mon Jan 2 18:21:50 2012 Errors IN file /oracle/admin/orcl/udump/orcl2_ora_630794.trc: ORA-00600: internal error code, arguments: [kgavsd_3], [0], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 1 ORA-01013: USER requested cancel OF CURRENT operation Mon Jan 2 18:21:51 2012 Trace dumping IS performing id=[cdmp_20120102182151] |
根据这三个错误综合判断，可以判断问题和Ora-600 kgavsd_3 [ID 403575.1]描述的一致，客户使用的多半是SQL DEVELOPER之类的工具，在使用DEBUG调试PL/SQL代码是出现了错误或中止了会话，导致DBMS_PIPE调用中断。
对于这个错误可以安全的将其忽略掉。