Re: java_pool

From: Tom Best <tom.best_at_bentley.com>
Date: 2000/08/02
Message-ID: <8m9mb5$oiv$1@news.bentley.com>#1/1

But what do you think of this, on a system that has no Java in use (as far as I know):

SQLWKS> select * from v$sgastat where pool='java pool'

     2>
POOL        NAME                       BYTES
----------- -------------------------- ----------
java pool   free memory                  20758528
java pool   memory in use                  212992

2 rows selected.

So, Oracle must do some java as part of its engine, so if you set this to 0, I would think you would have problems.

I tried setting it to zero, and this is the result:

SQLWKS> select * from v$sgastat where pool='java pool'

     2>
POOL        NAME                       BYTES
----------- -------------------------- ----------
java pool   free memory                      4096
java pool   memory in use                   28672

2 rows selected.

So it looks like it allocated what it needed, maybe in 4k chunks.

Interesting...

HTH,
Tom Best

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:3987F680.7168_at_yahoo.com...
> gdas wrote:
> >
> > Can anyone tell me what this init.ora parameter does?
> >
> > I'm doing an evaluation of our development system to free up
> > resources and this java_pool_size seems large:
> >
> > java_pool_size = 20971520
> >
> > I'm not a java developer. Everything we have on the oracle side
> > is written in PL/SQL. However, our application which this
> > database serves is written in java and connects to oracle via
> > JDBC... not sure if any of that matters to this parameter
> > though.
> >
> > If java_pool_size does matter to a JDBC client connection, any
> > tips on sizing it?
> >
> > Thanks,
> > Gavin
> >
> > -----------------------------------------------------------
> >
> > Got questions? Get answers over the phone at Keen.com.
> > Up to 100 minutes free!
> > http://www.keen.com
>
> Unless you are running java IN the database, then this memory is
> wasted...It has a minimum 1M.
>
> HTH
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk
>
> We are born naked, wet and hungry...then things get worse
Received on Wed Aug 02 2000 - 00:00:00 CDT

Re: java_pool_size???