admin管理员组

文章数量:1558098

Bug 11805372 - ORA-30009 "not enough memory" for certain CONNECT BY statements [ID 11805372.8]
 修改时间 22-SEP-2011     类型 PATCH     状态 PUBLISHED 

Bug 11805372  ORA-30009 "not enough memory" for certain CONNECT BY statements

This note gives a brief overview of bug 11805372.
The content was last updated on: 22-SEP-2011
Click here for details of each of the sections below.

Affects:

Product (Component)Oracle Server (Rdbms)
Range of versions believed to be affectedVersions BELOW 12.1
Versions confirmed as being affected
  • 11.2.0.2
Platforms affectedGeneric (all / most platforms affected)

Fixed:

This issue is fixed in
  • 12.1 (Future Release)
  • 11.2.0.3

Symptoms:

Related To:

  • Leak (Memory Leak / Growth)
  • Error May Occur
  • ORA-30009
  • Connect By / Hierarchical Queries

Description

ORA-30009 may be raised for certain CONNECT BY queries.
 
Rediscovery Notes:
 If an ORA-30009 is raised and the CONNECT BY query returns a constant value
 then this may be root cause if the CONNECT BY is a filter subquery.
 
Workaround
 None
HOOKS ERROR:ORA-30009 LIKELYAFFECTS XAFFECTS_11.2.0.1 XAFFECTS_V11020001 AFFECTS=11.2.0.1 XAFFECTS_11.2.0.2 XAFFECTS_V11020002 AFFECTS=11.2.0.2 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_CONNECTBY TAG_ERROR TAG_LEAK/MEM CONNECTBY ERROR LEAK/MEM FIXED_11.2.0.3 FIXED_12.1.0.0

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. For questions about this bug please consult Oracle Support.

References

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

本文标签： quotORABugidstatements

版权声明：本文标题：Bug 11805372 - ORA-30009 "not enough memory" for certain CONNECT BY statements [ID 11805372.8] 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://m.elefans.com/dianzi/1727341469a1109464.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。