Re: 8.1.6 to 8.1.7 JServer upgrade - very slow

Vsevolod Afanassiev wrote:
> I need to upgrade 8.1.6 database to 8.1.7 to try to get
> rid of some nasty ORA-00600. This wouldn't be a problem
> but the application users Oracle JServer, so I need
> to upgrade this component as well.
> The upgrade process is documented in Oracle8i Migration
> (page 7-31 Upgrading JServer) and several Metalink
> articles (for example, Note 161709.1). It works ... eventually.
>
> The problem is that it is VERY SLOW, takes about 6 hours
> on lightly loaded Sun Solaris box with plenty of memory.
> Main upgrade script jvmu816.sql leaves numerous classes
> in INVALID state. The recommendation is to re-compile them by
>
> ALTER JAVA CLASS "MyClass" RESOLVE;
>
> This is the longest part. I've run it with
> "set timing on" - many classes need 20 - 80 seconds
> to be resolved.
>
> Is there any way to speed up the process?
> - May be, try to resolve them in some
> particular order, something along the lines of
> $ORACLE_HOME/rdbms/admin/utlrp.sql?
> - May be, setting JAVA_POOL_SIZE to higher value will help?
>
> Thanks,
> Sev

It would - the "default" 20MB is about as ridiculous as the default shared pool of 3.5MB was...
And, yes - it takes long; I suspect (just a gut feeling) the implementation of Java on *nix has to do with it.

Frank Received on Wed Feb 05 2003 - 11:25:50 CST