服务器都128G内存，还报ora04030。郁闷，求助！

Yong Huang

原帖由 nailxu 于 2010-6-21 00:28 发表
原来是个BUG：
Bug 5883585 - ORA-4030 from long running XMLAGG query
...
Range of versions believed to be affected Versions < 11  
Versions confirmed as being affected 10.2.0.4
...
Fixed:
This issue is fixed in 10.2.0.4 Patch 5 on Windows Platforms
10.2.0.5 (Server Patch Set)
11.1.0.6 (Base Release)

升级到10.2.0.5后就不报错了。早听二楼的就好了，呵呵！感谢大家的关心和指导！

If 二楼 lfree had that bug in mind, he could have told us the bug number so we won't ignore a meaningful message. Indeed it's likely you're hitting that bug. Is it possible you do a test in 11g, or even 10.2.0.5 Windows?

Yong Huang

nailxu

好的，我试一下！

xin1shou3

试成功了吗？

原帖由 nailxu 于 2010-6-25 09:43 发表
好的，我试一下！