Re: (memory issue)Oracle 8.1.6 on NT 4.0

Adrian Shepherd wrote:
>
> Apologies if this is posted twice...
>
> Quoting from Metalink for 8.1.6
>
> The minimum value for java_pool_size is 1000000 in 8.1.5 and 32768 in 8.1.6
> and there is no maximum limit.
>
> - Jaikishan
> Oracle Support Services
>
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> news:39a243be$1_at_news.iprimus.com.au...
> >
> > "NetComrade " <andreyNSPAM_at_bookexchange.net> wrote in message
> > news:37bf1adc.24121935_at_news.earthlink.net...
> > > I think I have it set to 600K, don't remember how I came up with that
> > > #.
> >
> > A small wager that you haven't. At least -despite 4 months of trying, I
> > have been unable to start an 8i Instance with Java Shared Pool set to
> > anything lower than 1M.
> >
> > Have another look and get back to me (a sample from your init.ora would be
> > useful).
> >
> > Regards
> > HJR
> >
> >
> >
> > > On Sat, 19 Aug 2000 22:09:13 +1000, "Howard J. Rogers"
> > > <howardjr_at_www.com> wrote:
> > >
> > > >
> > > >"Darrell Cooley" <Darrell_Cooley_at_med.unc.edu> wrote in message
> > > >news:399C26C8.BB054C19_at_med.unc.edu...
> > > >> I have just upgraded from Oracle 8.0.4 to 8.1.6.
> > > >> and I have notice a great increase in the amount
> > > >> of memory the oracle.exe is using. I currently
> > > >> have 256MB and since upgrading it is now using the
> > > >> majority of that. Is this to be expected or is
> > > >> there any tuning I can do to alleviate this.
> > > >
> > > >Watch out for the java pool. If you upgraded an old database, your
 init.ora
> > > >wouldn't have an entry for this, so you'd be getting the
 efault -which
 is
> > > >20Mb. At this stage, you'll probably be wanting to use precisely zero
 of
> > > >this! Unfortunately, you can't switch the thing off entirely -the
 minimum
> > > >appears to be 1M. But at least you can save yourself 19M of wasted
 memory
> > > >by making an explicit declaration in the init.ora for
> > > >java_shared_Pool=1000000.
> > > >
> > > >In general, 8i is a lot hungrier than 8, and I would expect it to be
 more
 of
> > > >a resource hog as a result.
> > > >
> > > >Regards
> > > >HJR
> > > >
> > > >
> > >
> >
> >

Interestingly, when I used the database assistant under NT, it set the size to 0 (after I said "no java option")... and the database still came up...

( I haven't checked if it was silently enlarged to 32k)

Cheers

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

We are born naked, wet and hungry...then things get worse