Re: (memory issue)Oracle 8.1.6 on NT 4.0

I think you are right as I too cannot do away with the java shared pool. 600k is also coincindentally the min allowed for the large pool so that is probably what NetComrade was thinking of.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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

> > >

> > >

> >

>

>