ORA-30009: Not enough memory for CONNECT BY operation

最新推荐文章于 2023-05-23 13:32:49 发布

原创最新推荐文章于 2023-05-23 13:32:49 发布 · 2.7k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#ORA-30009

Oracle Troubleshooting 专栏收录该内容

9 篇文章

订阅专栏

本文讨论了Oracle数据库中遇到的一个常见错误ORA-30009，即在执行CONNECT BY操作时由于内存不足而无法完成的情况。详细描述了该错误的出现背景、受影响的产品版本、症状以及解决方法。通过分析，了解如何在不同版本的Oracle数据库中解决此内存不足的问题，特别关注于解决特定的CONNECT BY查询导致的内存溢出情况。

SQL> create table t as select rownum x from dual connect by level<10000000;
create table t as select rownum x from dual connect by level<10000000
                                       *
ERROR at line 1:
ORA-30009: Not enough memory for CONNECT BY operation


Elapsed: 00:00:01.14

1: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 articl