loadjava hangs - exclusive lock on sys.javasnm$
182248Aug 11 2005 — edited Aug 16 2005We upgraded from Oracle 9.2.0.4 to 9.2.0.5 (using export then import of the entire database) and have found that our user java classes that compiled fine in 9.2.0.4 aren't as lucky in 9.2.0.5. When we use "loadjava" to recompile the jar files, some compiles are successful and others hang. When we investigate the "hanging" ones we find an exclusive lock on sys.javasnm$. The only session doing a loadjava compile is mine. We kill the Oracle session, the exclusive lock goes away, we compile a few more jars successfully, then the "hanging" begins again. Can anyone explain what is going on? Thanks in advance.