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 affected Versions BELOW 12.1

Versions confirmed as being affected

11.2.0.2

Platforms affected Generic (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

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

ITPub博客

Bug 11805372 - ORA-30009

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

Affects:

Fixed:

Symptoms:

Related To:

Description

References

最新文章

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