操作系统: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 |
|
Platforms affected | Generic (all / most platforms affected) |
Fixed:
This issue is fixed in |
| |||
Symptoms: | Related To: | |||
|
| |||
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/