I’m having an intermittent problem with a Java Stored Procedure. I raised a TAR with Metalink who asked me to run oradebug against the process to pull out errorstacks. Doing this not only killed the session, but brought down the whole instance and OS!
Next I started to get errorstacks out using dbms_system.set_ev. This seemed to work, but it produced truncated errorstacks.
Now I’m debugging the errorstack production in order to allow me to debug the original Java issue.
The joys of running Oracle on Tru64…