Bug 11805372 - ORA-30009 "not enough memory" for certain CONNECT BY statements [ID 11805372.8]

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

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

References

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