memory leake issue in oracle.

Question

0.00/5 (No votes)

See more:

hi,
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.

Posted 30-Jan-14 21:24pm

samulcristina

Updated 5-Feb-14 19:10pm

v3

Add a Solution

Comments

Jörgen Andersson 31-Jan-14 7:33am

There's absolutely no chance to help you based on the info you provide.
What error message do you get?
How does the package look like?
What is the difference between the environments?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jörgen Andersson · Answer 1 · 2014-02-06T01:20:00

Solution 1

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.

Posted 6-Feb-14 1:20am

Jörgen Andersson

Comments

samulcristina 4-Mar-14 2:03am

thanks Andy,i understood the solution and have to put intermediate commits while calling objects to free the memory.as per me i need to use OCICacheFree() function to release memory after complete the session.
could you please give me an example how to use the above function in the package.

thanks in advance!!!!

Jörgen Andersson 4-Mar-14 2:40am

The Oracle Call Interface is Clientside and can't be used in a package.