This looks like a nasty one: I have modified a package (compiled a dozen times or so). This is done on my development PC.
In another instance of Toad, on a different machine (my test-PC), I execute a different package that calls various procedures in the package I hjave just been changing.
After the first few compiles, there are no issuse (other than my own bugs) and tests run as expected.
Then, it seems, a threshold has been exceeded and I start receiving ORA-06508 errors on my etst machine.
When I recycle Toad on my test-machine, the issue disappears and a normal test-run is possible.
However, as soon as I change the underlying package on my development machine, the test-machine’s Toad will complain about ORA-06508 again, until it is recycled.
I’m surprised that Toad should suffer from Oracle internal issues, yet the fact that recycling Toad (temporarily) alleviates the problem hints that it might be Toad issue, rather than an Oracle issue.
Any idea how we can figure out what exaqctly causes the symptoms and what we can do about it?
This is happening on Toad beta 18.104.22.168 (development) and 22.214.171.124 (test machine)
The Oracle instance is on Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production
I’ve had the issue before, and from experience I know that the problem will probably not reproduce tomorrow.
The issue does occur sometimes, and Always after compiling a package many times with many (small) changes.