Re: java_pool_size???

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