Re: impact of the JVM in the database (8.1.7)

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Wed, 10 Mar 2004 00:36:36 GMT
Message-ID: <404E6314.5FD7F7F8@remove_spam.peasland.com>

Bib Endum wrote:
>
> We never installed the integrated JVM in the database because we taught that
> it might cause more trouble that it's worth. It looks like it's using a lot
> of memory that could be better used for the OS and for the database cache.
>
> On the othre side, there are interesting things available with the JVM, like
> ftp and smtp and general networking classes. We have no Java guru in the
> shop, we merely want to use the available stuff.
>
> Is there any study explaining exactly what are the impacts of installing and
> using the JVM in the database ?
>
> Is this monster stable on 8.1.7.4 ?
>
> Thanks

As far as I've seen, it is stable in 8.1.7.4. The basic impacts are the increase memory usage, but you do have control over that with the JAVA_POOL_SIZE parameter. You might want to get start with Java in the database since more and more things are starting to require the JVM up and running.

HTH,
Brian Received on Tue Mar 09 2004 - 18:36:36 CST