Home » SQL & PL/SQL » SQL & PL/SQL » Memory issue - ORA-06508 PL/SQL: could not find.
Memory issue - ORA-06508 PL/SQL: could not find. [message #48698] Thu, 09 December 2004 04:31 Go to next message
Krupal Patel
Messages: 9
Registered: January 2004
Junior Member
ORA-06508 PL/SQL: could not find program unit being called

I got this error frequently in production database. And when database is bounced this error is resolved. So I am thinking it's memory issue.......We checked invalid object and there is not any invalid object.

Because same programs compiled in test database and it didn't give the error. It worked fine.

Please help what should I do to resolve this error? Everytime bounce the production database is not the correct solution. Your help is greatly appreciated.
Re: Memory issue - ORA-06508 PL/SQL: could not find. [message #48699 is a reply to message #48698] Thu, 09 December 2004 06:19 Go to previous messageGo to next message
Padders
Messages: 79
Registered: January 2004
Member
Version?
Re: Memory issue - ORA-06508 PL/SQL: could not find. [message #48700 is a reply to message #48699] Thu, 09 December 2004 06:55 Go to previous messageGo to next message
Krupal Patel
Messages: 9
Registered: January 2004
Junior Member
9i (release 902000500)
Re: Memory issue - ORA-06508 PL/SQL: could not find. [message #48717 is a reply to message #48700] Thu, 09 December 2004 23:41 Go to previous messageGo to next message
Padders
Messages: 79
Registered: January 2004
Member
Where do you get error? In the front end? Are you re-compiling or otherwise invalidating source code on the fly?
Re: Memory issue - ORA-06508 PL/SQL: could not find. [message #48731 is a reply to message #48717] Fri, 10 December 2004 08:45 Go to previous messageGo to next message
Krupal Patel
Messages: 9
Registered: January 2004
Junior Member
I am getting error in API. It's name is ClearOrbit (Gemini). This error was resolved temporarily by increasing SGA pool size. But once again we are facing this. I didn't get any compilation problem or invalidation object. Thank you for your help.
Re: Memory issue - ORA-06508 PL/SQL: could not find. [message #296848 is a reply to message #48698] Tue, 29 January 2008 05:02 Go to previous messageGo to next message
stackoverflow
Messages: 1
Registered: January 2008
Location: Moscow
Junior Member
http://ora-06508.ora-code.com/msg/49171.html
Re: Memory issue - ORA-06508 PL/SQL: could not find. [message #296917 is a reply to message #296848] Tue, 29 January 2008 08:32 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Good to see we have a new person willing to help out others, but you should note that you are answering a question from 4 years ago.
Previous Topic: aliasname
Next Topic: ORA-06533
Goto Forum:
  


Current Time: Sat Dec 03 07:53:11 CST 2016

Total time taken to generate the page: 0.05679 seconds