In 816 you can also set it to 0.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3d1b2e0e$0$8506$ed9e5944_at_reading.news.pipex.net...
> "Hemant K Chitale" <hkchital_nospam_at_singnet_nospam.com.sg> wrote in
message
> news:aff9n3$16r$1_at_reader01.singnet.com.sg...
> >
> > I believe 0 is a valid value for JAVA_POOL_SIZE in 8.1.7
> > [I just set it to 0 on my Win2K install and V$PARAMETER
> > shows 32768 as the java_pool_size !]
> > but not in 8.1.5. 8.1.5 errors out on the init.ora before
> > starting the instance if JAVA_POOL_SIZE is explicitly
> > set to 0.
>
> Thanks for the feedback. So it looks like zero (or less than 32k) is
treated
> as 32k in 8i.
>
> > Not sure if 9i allows JAVA_POOL_SIZE to be 0. I vaguely
> > remember that it does not allow it to be set to 0.
> >
> > However, I believe Frederic's 9i Instance is starting with
> > an SPFILE instead of the init.ora
> > Frederic, you could update the SPFILE by using the command
> > CREATE SPFILE '<filename>' FROM PFILE '<initorafilename>';
> > with the database shutdown and then restart the database.
>
> This is almost certainly correct.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
>
>
Received on Thu Jun 27 2002 - 11:30:43 CDT
