操作系统：Windows Server 2003 Version V5.2 Service Pack 1

数据库版本：Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production

日志报错：

Fri Nov 11 11:46:35 2011

Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_10012.trc:

ORA-00600: 内部错误代码, 参数: [qesmmCValStat4], [3], [1], [], [], [], [], []

Fri Nov 11 11:46:43 2011

Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_10012.trc:

ORA-00600: 内部错误代码, 参数: [qesmmCValStat4], [3], [1], [], [], [], [], []

又一个ORA-600错误，在matelink上查询了下，发现和Bug 4401437 - CONNECT BY query may fail with OERI qergiStart1相吻合。

Bug 4401437  CONNECT BY query may fail with OERI:qergiStart1 / OERI:qesmmCValStat4

 This note gives a brief overview of bug 4401437. 
 The content was last updated on: 03-APR-2009
 Click here for details of each of the sections below.

Affects:

Fixed:

Description

A connect-by query may fail with ORA-600 [qergiStart1]

Workaround

  Add a "no_filtering" hint to the query.

References

Bug:4401437 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article

    以上文章显示这是oracle的connect by分析函数的一个bug，采用Add a "no_filtering" hint to the query的方式处理，发现虽然不再报错，但查询出来的数据不准确。最终建议客户升级数据库到10.2.0.4稳定版本。

    不过升级数据库是个大操作，需要经过严密的应用测试才能实施。所以我建议重启数据库测试下，通过重启数据库释放资源，改变了触发bug的系统环境，使数据库恢复了正常。