Re: java_pool_size???

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

I deinstalled "Oracle Java Products" and bounced and got the same results.

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:39894790.AEF_at_yahoo.com...
> Tom Best wrote:
> >
> > 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

>

> Do you have the Java engine installed ? I'd be curios to see those
> figures if that option was not installed at all...

>
>

> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk

>
> We are born naked, wet and hungry...then things get worse
Received on Thu Aug 03 2000 - 00:00:00 CDT