oracle中的内存泄漏问题。 [英] memory leake issue in oracle.

问题描述

我在oracle 11.2版本中创建了一个软件包。

i已经在开发和测试环境中测试过并且工作得非常好。

我们已将此软件包部署到生产数据库中，然后我们遇到问题。



ORA-21780：超过最大对象持续时间数



我们使用了集合，'bulk collect into'和join来创建这个包。

有人可以告诉我为什么我们面临这个内存泄漏执行此程序包时来自oracle的问题。



提前感谢。

I have created one package in oracle 11.2 version.
i have tested in dev and test environments and working absolutely fine .
we have deployed this package into production database then we are getting below issue .

ORA-21780: Maximum number of object durations exceeded

we used collections,'bulk collect into' and joins to create this package .
can anybody tell me why we are facing this memory leakage issue from oracle while executing this package.

thanks in advance.

推荐答案

当你有对于不超出范围的许多对象（每个会话大于64000）。如果你有一个无限递归，这通常会发生。

如果这不是问题，它可能有助于制作中间提交 [ ^ ]。或者有多个交易。

This happens when you have to many objects (>64000 per session) that doesn't go out of scope. This commonly happens if you have an infinite recursion.
If this isn't the problem it might help to make intermediate commits[^]. Or having more than one transaction.

这篇关于oracle中的内存泄漏问题。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！