【故障-ORACLE】ORA-00600: [qesmmCValStat4], [3], [1] 故障处理-CSDN博客

操作系统：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 [ID 4401437.8]

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:

*Product (Component)*	Oracle Server (Rdbms)
*Range of versions believed to be affected*	Versions < 11
*Versions confirmed as being affected*	9.2.0.8 10.1.0.4 10.2.0.1
*Platforms affected*	Generic (all / most platforms affected)

Fixed:

*This issue is fixed in*		9.2.0.8 Patch 5 on Windows Platforms 10.1.0.5 (Server Patch Set) 10.2.0.2 (Server Patch Set) 11.1.0.6 (Base Release)
*Symptoms:*		*Related To:*
Internal Error May Occur (ORA-600) ORA-600 [qergiStart1] ORA-600 [qesmmCValStat4]		Connect By / Hierarchical Queries

Description

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

Workaround

Add a "no_filtering" hint to the query.

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.

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的系统环境，使数据库恢复了正常。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11088128/viewspace-710955/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11088128/viewspace-710955/